These are chat archives for getredash/redash

23rd
Apr 2017
Arik Fraimovich
@arikfr
Apr 23 2017 08:55
@AshvinSavani_twitter did you share the document with your service account email?
@runa thanks :) did you upgrade?
Abdelrahman Mahmoud
@ahamino
Apr 23 2017 17:14
Hey guys, just upgraded to 1.0.3+b2850
keep getting “error rendering pivot table UI
Arik Fraimovich
@arikfr
Apr 23 2017 17:19
@ahamino happens with every query?
Abdelrahman Mahmoud
@ahamino
Apr 23 2017 17:20
Good question ..
happens with athena query
deecay
@deecay
Apr 23 2017 17:52
@ahamino does every row have exactly the same number of columns?
Abdelrahman Mahmoud
@ahamino
Apr 23 2017 17:57
@deecay hmm I’m selecting a specific set of columns ..
SELECT evts.sessionid,
       evts.appname,
       evts.YEAR,
       evts.MONTH,
       evts.sdk,
       evts.sdkversion,
       evts.detector,
       evts.make,
       evts.model,
       evts_end.count
FROM sdkdatastore.events_two AS evts
and therefore I would expect the result to have the equal number of columns
for every row
deecay
@deecay
Apr 23 2017 18:03
@ahamino alright. I asked because I've seen that error when I had a returned resultset with variable column length.
Arik Fraimovich
@arikfr
Apr 23 2017 18:04
@ahamino any errors in the browser console?
Abdelrahman Mahmoud
@ahamino
Apr 23 2017 18:07
@arikfr
TypeError: Cannot read property 'android' of undefined
    at pivot.js:1040
    at Function.t.forEachRecord (pivot.js:583)
    at ye.fn.init.e.fn.pivotUI (pivot.js:1028)
    at index.js:46
    at p.$digest (angular.js:17524)
    at p.$apply (angular.js:17790)
    at HTMLSelectElement.<anonymous> (angular.js:31142)
    at Ge (angular.js:3497)
    at HTMLSelectElement.n (angular.js:3485)
android should be one of the results in evts.sdk
Arik Fraimovich
@arikfr
Apr 23 2017 18:08
one of the row values?
Abdelrahman Mahmoud
@ahamino
Apr 23 2017 18:08
yea
this is also one of the columns I would expect to have NULLs
or empty values for some of the records
Arik Fraimovich
@arikfr
Apr 23 2017 18:10
does the first row have a null?
Abdelrahman Mahmoud
@ahamino
Apr 23 2017 18:10
yep
Arik Fraimovich
@arikfr
Apr 23 2017 18:10
can you try to sort the result so that the first row doesn't have nulls? (just for the sake of testing)
Abdelrahman Mahmoud
@ahamino
Apr 23 2017 18:43
@arikfr sorting in the UI didn’t work .. sorting in the QUERY worked
Arik Fraimovich
@arikfr
Apr 23 2017 18:50
yes, I meant in the query. seems like the pivot lib takes some assumptions based on the first value :\
Ashvin Savani
@AshvinSavani_twitter
Apr 23 2017 20:21
@arikfr you mean sharing the spreadsheet with Name@ClientID (redash-user@long-client-id.apps.googleusercontent.com)? At that time I did not shared with it but just now shared it but same error!
just10minutes
@just10minutes
Apr 23 2017 20:37
@arikfr do you have any plans to support Teradata database?