You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Xiao Li (JIRA)" <ji...@apache.org> on 2019/07/17 16:48:00 UTC
[jira] [Updated] (SPARK-24570) SparkSQL - show schemas/tables in
dropdowns of SQL client tools (ie Squirrel SQL, DBVisualizer.etc)
[ https://issues.apache.org/jira/browse/SPARK-24570?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Xiao Li updated SPARK-24570:
----------------------------
Issue Type: Sub-task (was: Improvement)
Parent: SPARK-28426
> 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: Sub-task
> Components: SQL
> Affects Versions: 2.3.1
> Reporter: t oo
> Assignee: Yuming Wang
> Priority: Major
> Fix For: 3.0.0
>
> Attachments: connect-to-sql-db-ssms-locate-table.png, hive.png, spark.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):
> {code:java}
> Title: An Error Occurred
> Summary: Unable to Enumerate Result
> ==================================== Start Message ====================================
> org.apache.spark.sql.catalyst.parser.ParseException:
> mismatched input '`*`' expecting STRING(line 1, pos 38)
> == SQL ==
> SHOW TABLE EXTENDED FROM sit1_pb LIKE `*`
> --------------------------------------^^^
> ==================================== End Message ====================================
> ==================================== Start Stack Trace ====================================
> java.sql.SQLException: org.apache.spark.sql.catalyst.parser.ParseException:
> mismatched input '`*`' expecting STRING(line 1, pos 38)
> == SQL ==
> SHOW TABLE EXTENDED FROM sit1_pb LIKE `*`
> --------------------------------------^^^
> at org.apache.hive.jdbc.HiveStatement.execute(HiveStatement.java:296)
> at com.aquafold.aquacore.open.rdbms.drivers.hive.Qꐨꈬꈦꁐ.execute(Unknown Source)
> at \\.\\.\\हिñçêČάй語简�?한\\.gᚵ᠃᠍ꃰint.execute(Unknown Source)
> at com.common.ui.tree.hꐊᠱꇗꇐ9int.yW(Unknown Source)
> at com.common.ui.tree.hꐊᠱꇗꇐ9int$1.process(Unknown Source)
> at com.common.ui.util.BackgroundThread.run(Unknown Source)
> ==================================== End Stack Trace ====================================
> {code}
--
This message was sent by Atlassian JIRA
(v7.6.14#76016)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org