<p dir="auto">Hi,<br>
I am using Superset 0.19.0 to connect Spark Sql. I need to query my temp tables in spark. The database is created and connection is OK. I also was able to create a table by selecting my database connection and giving the table name and empty schema name ( Spark temp tables don't have a database/schema ). I am able to load data from my table and visualize it.<br>
<a target="_blank" rel="noopener noreferrer nofollow" href="https://user-images.githubusercontent.com/8961517/29110753-087f6564-7cfd-11e7-9923-a75c5b7ae381.png"><img src="https://user-images.githubusercontent.com/8961517/29110753-087f6564-7cfd-11e7-9923-a75c5b7ae381.png" alt="tables1" style="max-width: 100%;"></a></p>
<p dir="auto">Now I want to query my tables from SQL Lab, but I can't access the tables. The reason is that If I don't select any schema, I can't see or search my table names.</p>
<p dir="auto"><a target="_blank" rel="noopener noreferrer nofollow" href="https://user-images.githubusercontent.com/8961517/29111287-e4d5933e-7cfe-11e7-95ac-fd228b08c129.png"><img src="https://user-images.githubusercontent.com/8961517/29111287-e4d5933e-7cfe-11e7-95ac-fd228b08c129.png" alt="sqllab" style="max-width: 100%;"></a></p>
<p dir="auto">Is it possible to make SQL Lab view and query tables which are NOT in any database/schema?</p>
<p dir="auto">Make sure these boxes are checked before submitting your issue - thank you!</p>
<ul class="contains-task-list">
<li class="task-list-item"><input type="checkbox" id="" disabled="" class="task-list-item-checkbox" checked=""> I have checked the superset logs for python stacktraces and included it here as text if any</li>
<li class="task-list-item"><input type="checkbox" id="" disabled="" class="task-list-item-checkbox" checked=""> I have reproduced the issue with at least the latest released version of superset</li>
<li class="task-list-item"><input type="checkbox" id="" disabled="" class="task-list-item-checkbox" checked=""> I have checked the issue tracker for the same issue and I haven't found one similar</li>
</ul>
<h3 dir="auto">Superset version</h3>
<p dir="auto">0.19.0</p>
<h3 dir="auto">Expected results</h3>
<p dir="auto">To be able to see the tables in SQL LAB and if I select one of them see a short summary of the selected table and its columns. Another expectation would be to autosuggest the table names and columns in the SQL LAB editor.</p>
<h3 dir="auto">Actual results</h3>
<p dir="auto">I can't see any Temporary Table names in the dropdown menu plus there is no suggestion about the created Temporary Tables or their columns in the query editor. However I'm able to query the tables and getting the appropriate results in the results tab.<br>
Additional information that connecting to Spark SQL via beeline command line tool shows that all the Temporary Tables were created and registered (show tables command) and their columns can be seen as well (show columns from sometable command).<br>
<a target="_blank" rel="noopener noreferrer nofollow" href="https://user-images.githubusercontent.com/18054466/29020072-161ad26e-7b61-11e7-95b3-113edd4acb9f.png"><img width="959" alt="spark_issue" src="https://user-images.githubusercontent.com/18054466/29020072-161ad26e-7b61-11e7-95b3-113edd4acb9f.png" style="max-width: 100%;"></a></p>
<h3 dir="auto">Steps to reproduce</h3>
<ol dir="auto">
<li>Start a Spark Context and set spark.sql.hive.thriftServer.singleSession to true.</li>
<li>Start a Spark Thrift Server in the already created and started Spark context.</li>
<li>Create some Temporary Tables in the Spark context.</li>
<li>Connect to Spark SQL with Pyhive SQLAlchemy URI.</li>
</ol>