[GitHub] bobzdar commented on issue #2483: [question] : Support Spark SQL standalone

[gi...@git.apache.org]

bobzdar commented on issue #2483: [question] : Support Spark SQL standalone 
URL: https://github.com/apache/incubator-superset/issues/2483#issuecomment-315162633
 
 
   I can connect using the hive:// sql alchemy, but it throws a "Could not locate column in row for column 'database_name'" error when I save the connector as there are no tables in the default (or any other) database - all tables are in global_temp to allow multi-session thrift usage for resource management purposes and thrift does not allow you to set global_temp as the default database since it's a system preserved database.  The issue with multi session mode is that it creates a new session for each connection and will not have any tables loaded, so I'm trying to figure out how to create a (dummy) table when the connection is initiated (using metadata_params?) to allow it to find a table and save.  Then I should be able to query the global_temp tables.
   
   If you run thrift in single session mode and create some tables or views before connecting superset, it should work.  I did have to install some sasl dependencies on the superset python install to get it to connect.
   
   If you get a SASL error on connect, start thrift in NOSASL mode and specify "auth":"NOSASL" in engine_params in superset, or try the following:
   
   pip install thrift-sasl
   pip install sasl
   pip install thriftpy
   yum -y install cyrus-sasl-plain
   
   Hope this helps.
 
----------------------------------------------------------------
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