[GitHub] darylerwin opened a new issue #4392: bigquery select putting in extra "schema" in the column names.

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

darylerwin opened a new issue #4392: bigquery select putting in extra "schema" in the column names.
URL: https://github.com/apache/incubator-superset/issues/4392
 
 
   Make sure these boxes are checked before submitting your issue - thank you!
   
   - [ ] I have checked the superset logs for python stacktraces and included it here as text if any
   - [ ] I have reproduced the issue with at least the latest released version of superset
   - [ ] I have checked the issue tracker for the same issue and I haven't found one similar
   
   
   ### Superset version
   Latest
   
   ### Expected results
   (google.cloud.bigquery.dbapi.exceptions.DatabaseError) [{u'reason': u'invalidQuery', u'message': u'Unrecognized name: abc at [1:12]', u'location': u'query'}]
   
   ### Actual results
   
   
   ### Steps to reproduce
   Created table.
   It generates what looks to be somewhat correct sql except for the schema in front of the dataset.column name in the select statement.
   
   table is defined as abc.revenue
   schema is left blank
   database is defined as bigquery://myprojectid/
   
   It looks as thought `myschema.revenue`.`exchange_rate` would work! .. so just the extra ` ` are causing the problem.
   
   SELECT SUM(`myschema`.`revenue`.`exchange_rate`) AS `sum__exchange_rate`
   FROM `abc.revenue`
   WHERE `day` >= '2018-02-02'
     AND `day` <= '2018-02-09'
   ORDER BY `sum__exchange_rate` DESC
   LIMIT 5000
   
   

----------------------------------------------------------------
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