[
https://issues.apache.org/jira/browse/SPARK-24570?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
t oo updated SPARK-24570:
-------------------------
Description:
An end-user SQL client tool (ie in the screenshot) can list tables from
hiveserver2 and major DBs (Mysql, postgres,oracle, MSSQL..etc). But with
SparkSQL it does not display any tables. This would be very convenient for
users.
This is the exception in the client tool (Aqua Data Studio):
org.apache.spark.sql.catalyst.parser.ParseException: mismatched input '`*`'
expecting STRING(line 1, pos 38) == SQL == SHOW TABLE EXTENDED FROM sit1_pb
LIKE `*` --------------------------------------^^^
was:An end-user SQL client tool (ie in the screenshot) can list tables from
hiveserver2 and major DBs (Mysql, postgres,oracle, MSSQL..etc). But with
SparkSQL it does not display any tables. This would be very convenient for
users.
> SparkSQL - show schemas/tables in dropdowns of SQL client tools (ie Squirrel
> SQL, DBVisualizer.etc)
> ---------------------------------------------------------------------------------------------------
>
> Key: SPARK-24570
> URL: https://issues.apache.org/jira/browse/SPARK-24570
> Project: Spark
> Issue Type: New Feature
> Components: SQL
> Affects Versions: 2.3.1
> Reporter: t oo
> Priority: Major
> Attachments: connect-to-sql-db-ssms-locate-table.png
>
>
> An end-user SQL client tool (ie in the screenshot) can list tables from
> hiveserver2 and major DBs (Mysql, postgres,oracle, MSSQL..etc). But with
> SparkSQL it does not display any tables. This would be very convenient for
> users.
> This is the exception in the client tool (Aqua Data Studio):
> org.apache.spark.sql.catalyst.parser.ParseException: mismatched input '`*`'
> expecting STRING(line 1, pos 38) == SQL == SHOW TABLE EXTENDED FROM sit1_pb
> LIKE `*` --------------------------------------^^^
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
