These are chat archives for getredash/redash

7th
Jul 2016
sivasankarmanuh
@sivasankarmanuh
Jul 07 2016 03:24
Hi Arik, is redash 0.4.0+b589 support the impala and hive data sources?
Arik Fraimovich
@arikfr
Jul 07 2016 03:31
@ramyakalyan_twitter did you put the alias in quotes?
@sivasankarmanuh no, it was introduced in later versions
sivasankarmanuh
@sivasankarmanuh
Jul 07 2016 04:48
Thanks Arik.
Arik Fraimovich
@arikfr
Jul 07 2016 04:49
@sivasankarmanuh if you have issues upgrading your 0.40 install, maybe try creating a new instance with latest version and transfer data from the old one?
sivasankarmanuh
@sivasankarmanuh
Jul 07 2016 04:50
ok
Getting scripting issues and internal server issues when I am using fabfile script.
I will try with new instance.
Arik Fraimovich
@arikfr
Jul 07 2016 04:53
if you have a lot of stuff on the old one that it will be a hassle to transfer, you can try doing the upgrade manually step by step, and fixing issues that come up
sivasankarmanuh
@sivasankarmanuh
Jul 07 2016 04:54
Ok Arik
I am new to redash, Is redash scripts working for centos?
martin sarsale
@runa
Jul 07 2016 10:53
Aloha! Long time no see :)
Arik Fraimovich
@arikfr
Jul 07 2016 10:53
@runa aloha :-)
@sivasankarmanuh I tested only on Ubuntu.
martin sarsale
@runa
Jul 07 2016 10:54
@arikfr how're you doing?
Arik Fraimovich
@arikfr
Jul 07 2016 10:54
@runa doing good. and you're? :)
martin sarsale
@runa
Jul 07 2016 10:54
@arikfr pretty good. we're launching a new feature and I'm writting the dashboards to monitor it :)
Arik Fraimovich
@arikfr
Jul 07 2016 10:55
:) that's a good workflow!
martin sarsale
@runa
Jul 07 2016 10:55
@arikfr "it's not in production until it's monitored and visualized"
@arikfr someone said that. my feature is already in production, and the dashboard is not there yet
and let's not start talking about monitoring ;)
@arikfr so, I was looking for an example of a Kibana query
Federico Ponzi
@FedericoPonzi
Jul 07 2016 11:04
Hi again :) if i want to extend the "FormatSQL" capabilities adding some more custom commands, where should I start looking at?
Arik Fraimovich
@arikfr
Jul 07 2016 11:05
@runa I didn't use the Kibana integration much, but iirc it takes a similar query to what you would enter in their UI. See here: http://docs.redash.io/en/latest/usage/elasticsearch_querying.html
@FedericoPonzi what would you like to add?
martin sarsale
@runa
Jul 07 2016 11:06
@arikfr "logstash elasticsearch instance" ?
Arik Fraimovich
@arikfr
Jul 07 2016 11:06
yes, I think
Federico Ponzi
@FedericoPonzi
Jul 07 2016 11:07
I've made a custom datasource, which I can query with SQL. I've extended SQL to support variables, but when I press format i loose the format and I get all variables in one line
Arik Fraimovich
@arikfr
Jul 07 2016 11:07
hmm... we use sqlparse lib to do the sql formatting, you can see if you can extend its capabilities
Federico Ponzi
@FedericoPonzi
Jul 07 2016 11:08
Ah! I see
thanks
sivasankarmanuh
@sivasankarmanuh
Jul 07 2016 13:12
Thanks Arik, finally I connected impala.
Getting following error when I am trying to connect hive
Error running query: 'NoneType' object has no attribute 'close'
Ramya Kalyanaraman
@ramyakalyan_twitter
Jul 07 2016 15:55
@arikfr yes i mentioned it in single quotes.
Ramya Kalyanaraman
@ramyakalyan_twitter
Jul 07 2016 16:32
@arikfr I tried giving the alias without quotes as well but I just end up getting the table view and no filters
Never mind I just figured out that i have to use double underscore and it worked.. Thanks :)