These are chat archives for getredash/redash

15th
Mar 2016
Arik Fraimovich
@arikfr
Mar 15 2016 06:20
@scottkrager you can try and open an issue on their repo... when they add support, we can update our version.
Lloyd Weehuizen
@lloydw
Mar 15 2016 06:24
I've managed to graph a few things from from MySQL and really impressed so far, now trying to query from ElasticSearch but whatever I put in the query (even a slight modification from the docs -http://docs.redash.io/en/latest/usage/elasticsearch_querying.html) I get "Error running query: hits". Not sure how to proceed, whats the minimum elasticsearch version supported? Thanks
Arik Fraimovich
@arikfr
Mar 15 2016 06:42
@lloydw it fails to find "hits" key in the JSON response from ElasticSearch. You can try to check in the logs (/opt/redash/logs/celery_error.log) what is the query it sends and what the response it gets from ES
markchatters
@markchatters
Mar 15 2016 06:44
@arikfr - nice job on re:dash. I have a couple of questions.
Arik Fraimovich
@arikfr
Mar 15 2016 06:45
@markchatters thanks :)
markchatters
@markchatters
Mar 15 2016 06:48
I notice you are using plotly - Q1) are there any plans to include a 3d surface plot ? and Q2) Is there any way to support "cascading list of values" or hierarchal filters ?
(so what I mean by that is I have a huge dataset - and to help users query it I need a drill-down filter - e.g. First Select a country, then select states or regions in a country, then cities within a region....
Arik Fraimovich
@arikfr
Mar 15 2016 06:54
  1. No specific plans. But I do plan on making creating new visualizations easier, so maybe someone else will create it...
  2. Should those filters be applied on the client side (query returns all results and we just filter them) or server side (we render a new query based on filters)?
Lloyd Weehuizen
@lloydw
Mar 15 2016 06:56
@arikfr thanks, found the issue, it seems the query is a little more complex than the example, query needs to be "query" : { "query_string": { "query": "type:events" } },
@arikfr also, a question about moving re:dash between servers, will a fresh install plus a simple postgress dump and reload transfer all the required config?
markchatters
@markchatters
Mar 15 2016 06:57
  1. OK thanks for the info
  2. Server side - and if the list of values could be built from another query (or cached) that would be great
Arik Fraimovich
@arikfr
Mar 15 2016 06:58
@lloydw yes, you just need to move the PG data.
@markchatters so yes, something like this is planned for when we add UI for the parameter feature (example: demo.redash.io/queries/146/source?p_action=create). But you can already create something like this in a crude way using a query that returns links to a parameterized query filtered by the first query. Something like: http://demo.redash.io/queries/520#table
markchatters
@markchatters
Mar 15 2016 07:02
@arikfr - Ok thanks - I will have a look
Lloyd Weehuizen
@lloydw
Mar 15 2016 07:05
@arikfr thanks for the fast responses, enjoying learning your fantastic tool.
Lloyd Weehuizen
@lloydw
Mar 15 2016 07:30
@arikfr I'd like to write queries on results of other queries, Eg pull in records from elasticsearch and mysql then write a combined query on those two results. I think this could be done by using the JSON functions in postgres 9.4, accessing the data field of the query_results in redash:meta db. Any reason you could think this wouldn't work?
Arik Fraimovich
@arikfr
Mar 15 2016 07:31
@lloydw I was planning to support queries on query results. Never thought of using the json functions for this. If you get to try this, I'll be happy to hear how it worked for you.
Lloyd Weehuizen
@lloydw
Mar 15 2016 07:42
ok, i'll give it a try!
Lloyd Weehuizen
@lloydw
Mar 15 2016 08:11
Is there a list of action::* functions somewhere?
Arik Fraimovich
@arikfr
Mar 15 2016 08:12
nope, but iirc, it's only ::fitler and ::multi-filter (or filter / multiFitler for databases that don't support :: in column aliases)
Lloyd Weehuizen
@lloydw
Mar 15 2016 08:12
cool
Arik Fraimovich
@arikfr
Mar 15 2016 08:12
gitter changed the text, it should be __filter / __multiFilter)
Lloyd Weehuizen
@lloydw
Mar 15 2016 08:12
ta
was just looking at pull request #926, how do you use the min/max functions?
Arik Fraimovich
@arikfr
Mar 15 2016 08:15
It's for the Python query runner.
Lloyd Weehuizen
@lloydw
Mar 15 2016 08:15
ok, thats for plugins?
Arik Fraimovich
@arikfr
Mar 15 2016 08:15
Btw, that's another option for merging query results. Although you should know that the Python query runner isn't really safe (although the code runs in a sandbox).
No, it's a query runner like the MySQL or ElasticSearch one, but it takes Python code as a query and executes it.
here's an example:
Lloyd Weehuizen
@lloydw
Mar 15 2016 08:18
ah nice! how do I enable the python data source?
Lloyd Weehuizen
@lloydw
Mar 15 2016 08:21
sweet, thanks
so which is preferred for communication, gitter or slack?
Arik Fraimovich
@arikfr
Mar 15 2016 08:25
the idea is to migrate to Slack, but I'm still hanging around here as I didn't have the time to update all the references to this channel...
Lloyd Weehuizen
@lloydw
Mar 15 2016 08:25
:)
markchatters
@markchatters
Mar 15 2016 21:45
@arikfr - another quick question - is there a way of running a query to get data between 2 dates (e.g. SELECT * FROM MEASUREMENTS WHERE MEASUREMENT_DATE BETWEEN :X and :Y) - or does that need a UI for parameters ?