[GitHub] jhettler commented on issue #4770: Cannot display Time Series Line Chart

[GitBox <gi...@apache.org>]

jhettler commented on issue #4770: Cannot display Time Series Line Chart
URL: https://github.com/apache/incubator-superset/issues/4770#issuecomment-379154535
 
 
   Hi, I have found the similar issue yesterday on 0.24.0. 
   
   In my case, we use Snowflake database and I expected it is related to DB engine and I am still not sure what's exactly wrong, everything works fine with Superset examples and as well if I add the tables from Snowflake straight from dialog Sources/Tables/Add table (plus icon in right upper corner). But if I try to create datasource/table from query it didn't work. Then I realize there are quotes around column names in query (view query menu in graph view - upper right corner). 
   
   Same as in @syzuhdi case
   
   > SELECT "CITY",
   > "timestamp",
   > "count_QTY"
   
   I tried to lowercase all column names and whoila, everything works. Lowercased name of columns are not in doublequotes and it is correctly interpreted.
   
   I made following steps:
   1. Run a query in SQL lab
   2. Visualize it - it will ask for datasource name
   3. Save the visualization
   4. Go to Sources/Tables and edit the table/datasource you created in step 2
   5. Rename all columns to lowercase 
   6. Try to visualize graph
   
   It's not nice, but it works for us as a temporary workaround.
   HTH.

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services