These are chat archives for getredash/redash

2nd
Feb 2017
Will
@wihodges
Feb 02 2017 01:43
Question so I rebooted Ubuntu server with Redash- and now redash UI won't load up. ran sudo supervisorctl restart all but that did nothing. Thinking its nginx issue / when I look at the /var/log/nginx/rd.access.log I can see my most recent requests . Any ideas of what to do next - Thanks!
Arik Fraimovich
@arikfr
Feb 02 2017 07:06
@wihodges what was the output of running supervisorctl restart all?
Florian Pieront
@fpieront
Feb 02 2017 10:28
hi @arikfr , I expanded the hack for default parameters here (https://redash.io/help/query-examples-hacks/redash-hacks.html#default-param-value) to allow using several parameters, all of which can be either 'All' or a specific value
it's not pretty, but it works
SELECT *
FROM table
WHERE CASE
          WHEN ('{{Param 1}}' = 'All'
                AND '{{Param 2}}' = 'All'
                AND '{{Param 3}}' = 'All' THEN TRUE
          ELSE ((COALESCE(NULLIF('{{Param 1}}', '*'), param1_column::TEXT) = param1_column::TEXT)
                AND (COALESCE(NULLIF('{{Param 2}', '*'), param2_column::TEXT) = param2_column::TEXT)
                AND (COALESCE(NULLIF('{{Param 3}}', '*'), to_char(param3_column, 'YYYY-MM-DD'))::DATE < param3_column+ '1 day'::INTERVAL)
This works for param 3 being a date field and used as an "End date" parameter
janusd
@janusd
Feb 02 2017 14:15
Hej everyone, first of all thanks for that great project! I was wondering why the cassandra driver is not in the default data source options? Are there any known problems? I upgraded the driver and I'm using a cassandra node with the stratio lucene index plugin. For me no troubles yet.
Will
@wihodges
Feb 02 2017 16:05
@arikfr per issue with restarting server and not having redash render. I think I screwed something up by manually installing GA API Python a couple days earlier trying to do GA API embeds. Interestingly this didn't mess anything up at time, but things got really strange b/c CPU was maxing out at 100% and 'supervisorctl restart all' eventually throwing localhost:9000 not available. Fortunately, I just rolled server back a couple of days and everything just works great again.
Will
@wihodges
Feb 02 2017 18:40
Hey anybody else experiencing Timeout/crashes for PSQL queries that worked in 0.12 but not 1.0
Nii
@niibruce
Feb 02 2017 22:39
Have the help pages been moved somewhere else? Getting page not found errors on multiple URLs https://redash.io/help/data-sources/google-analytics.html
janusd
@janusd
Feb 02 2017 22:51
@niibruce same for me (even https://redash.io/ )
Nii
@niibruce
Feb 02 2017 23:23
@janusd They're back now. (well some of the pages that weren't available for me earlier, at least)
Arik Fraimovich
@arikfr
Feb 02 2017 23:41
@niibruce it should be all back now. the hosting provider had some issues... luckily toddler woke me up and I saw your messages :) (it's almost 2am here)
@wihodges not sure if the GA query runner related to your issue.
@janusd to be honest, I don't remember why it wasn't included... might be an oversight.
@fpieront nice! need to review the query when I'm a bit more awake :)