These are chat archives for getredash/redash

28th
Jun 2016
Teguh Nugraha
@teguhn_twitter
Jun 28 2016 04:14
Hi. I'm trying to embed some visualiations in a static html, but I got this
"Refused to display in a frame because it set 'X-Frame-Options' to 'SAMEORIGIN'"
Arik Fraimovich
@arikfr
Jun 28 2016 07:24
@teguhn_twitter how did you setup Redash?
moshe0076
@moshe0076
Jun 28 2016 12:48
@arikfr
Hi,
I have a problem when running hive query's:
[2016-06-28 12:48:18,193: ERROR/Worker-853] global name 'hive' is not defined
Traceback (most recent call last):
File "/opt/redash/redash.0.10.1.b1834/redash/query_runner/hive_ds.py", line 94, in run_query
connection = hive.connect(self.configuration.to_dict())
NameError: global name 'hive' is not defined
[2016-06-28 12:48:18,194: ERROR/MainProcess] Task redash.tasks.execute_query[fe51e3c9-d026-4e07-b014-f562305c6040] raised unexpected: AttributeError("'NoneType' object has no attribute 'close'",)
Traceback (most recent call last):
File "/usr/local/lib/python2.7/dist-packages/celery/app/trace.py", line 240, in trace_task
R = retval = fun(*args,
kwargs)
File "/opt/redash/redash.0.10.1.b1834/redash/tasks/base.py", line 13, in call
return super(BaseTask, self).call(args, **kwargs)
File "/usr/local/lib/python2.7/dist-packages/celery/app/trace.py", line 437, in protected_call
return self.run(
args, **kwargs)
File "/opt/redash/redash.0.10.1.b1834/redash/tasks/queries.py", line 438, in execute_query
return QueryExecutor(self, query, data_source_id, metadata).run()
File "/opt/redash/redash.0.10.1.b1834/redash/tasks/queries.py", line 388, in run
data, error = query_runner.run_query(annotated_query)
File "/opt/redash/redash.0.10.1.b1834/redash/query_runner/hive_ds.py", line 127, in run_query
connection.close()
AttributeError: 'NoneType' object has no attribute 'close'
Antoine Augusti
@AntoineAugusti
Jun 28 2016 13:03
@moshe0076 Looks like the same as this issue getredash/redash#1076
moshe0076
@moshe0076
Jun 28 2016 13:08

OK, I get
Python 2.7.6 (default, Jun 22 2015, 17:58:13)
[GCC 4.8.2] on linux2
Type "help", "copyright", "credits" or "license" for more information.

from pyhive import hive
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "/usr/local/lib/python2.7/dist-packages/pyhive/hive.py", line 10, in <module>
from TCLIService import TCLIService
ImportError: No module named TCLIService

How to fix??
Arik Fraimovich
@arikfr
Jun 28 2016 13:17
@moshe0076 see what Nabil did here: https://github.com/getredash/redash/pull/1077/files and apply the same to your instance.
moshe0076
@moshe0076
Jun 28 2016 13:22
Now it loads the hive module but I get:
[2016-06-28 13:21:49,008: ERROR/Worker-949] global name 'hive' is not defined
Traceback (most recent call last):
File "/opt/redash/redash.0.10.1.b1834/redash/query_runner/hive_ds.py", line 94, in run_query
connection = hive.connect(self.configuration.to_dict())
NameError: global name 'hive' is not defined
[2016-06-28 13:21:49,011: ERROR/MainProcess] Task redash.tasks.execute_query[fca9ff14-a241-4ed9-8c57-822e64204bb5] raised unexpected: AttributeError("'NoneType' object has no attribute 'close'",)
Traceback (most recent call last):
File "/usr/local/lib/python2.7/dist-packages/celery/app/trace.py", line 240, in trace_task
R = retval = fun(*args,
kwargs)
File "/opt/redash/redash.0.10.1.b1834/redash/tasks/base.py", line 13, in call
return super(BaseTask, self).call(args, **kwargs)
File "/usr/local/lib/python2.7/dist-packages/celery/app/trace.py", line 437, in protected_call
return self.run(
args, **kwargs)
File "/opt/redash/redash.0.10.1.b1834/redash/tasks/queries.py", line 438, in execute_query
return QueryExecutor(self, query, data_source_id, metadata).run()
File "/opt/redash/redash.0.10.1.b1834/redash/tasks/queries.py", line 388, in run
data, error = query_runner.run_query(annotated_query)
File "/opt/redash/redash.0.10.1.b1834/redash/query_runner/hive_ds.py", line 127, in run_query
connection.close()
AttributeError: 'NoneType' object has no attribute 'close'
contractor05
@contractor05
Jun 28 2016 13:43
Hi
SELECT top 10 DATEPART('WEEK', Timestamp_Creation) as creation_week from tbl_name;
the above query is not working
any ideas y????
getting below error
Error running query: function pg_catalog.date_part("unknown", character varying) does not exist HINT: No function matches the given name and argument types. You may need to add explicit type casts.
contractor05
@contractor05
Jun 28 2016 14:10
is this a support chat??
Antoine Augusti
@AntoineAugusti
Jun 28 2016 14:11
@contractor05 This is a Postgres error. You should use DATEPART(WEEK, Timestamp_Creation) instead
contractor05
@contractor05
Jun 28 2016 14:12
already tried
SELECT top 10 DATEPART(WEEK, Timestamp_Creation) as creation_week from tbl_name;
still giving me error
Error running query: function pg_catalog.date_part("unknown", character varying) does not exist HINT: No function matches the given name and argument types. You may need to add explicit type casts.
any ideas antonie augusti?
Teguh Nugraha
@teguhn_twitter
Jun 28 2016 14:24

@arikfr I setup redash using AMI

@teguhn_twitter how did you setup Redash?

I'm trying to embed some visualizations in a static html, but I got this
"Refused to display in a frame because it set 'X-Frame-Options' to 'SAMEORIGIN'"

contractor05
@contractor05
Jun 28 2016 14:27
hello?
anybody there?
Teguh Nugraha
@teguhn_twitter
Jun 28 2016 14:29
@contractor05 try DATEPART('WEEK', Timestamp_Creation::timestamp)
contractor05
@contractor05
Jun 28 2016 16:26
not working
tried
SELECT top 10 DATEPART('week', Timestamp_Creation::timestamp) from tbl_name group by DATEPART('week', Timestamp_Creation::timestamp);
getting below message
Error running query: Invalid data DETAIL: ----------------------------------------------- error: Invalid data code: 8001 context: Invalid format or data given: 02/21/2007 01:42:38 query: 367991 location: funcs_timestamp.cpp:174 process: query0_42 [pid=1246] -----------------------------------------------
why is redash not supporting just basic queries ?
am surprised
contractor05
@contractor05
Jun 28 2016 16:48
Guys can u please respond ?
is there any support email
Tom
@tomkanjam
Jun 28 2016 20:11
This message was deleted