[jira] [Commented] (SPARK-29985) Spark integrated Hive ---cannot read database and table in hive

["lv haiyang (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/SPARK-29985?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16979105#comment-16979105 ] 

lv haiyang commented on SPARK-29985:
------------------------------------

the Spark version 2.3.2 and Hive version 3.1.0
 # From the SPARK_HOME directory, launch Beeline:
su spark
./bin/beeline
 # At the Beeline prompt, connect to the Spark SQL Thrift server with the JDBC connection string:
beeline> !connect jdbc:hive2://localhost:10016

but there is nothing databases and tables were founded in spark sql,is there anything wrong ?

> Spark integrated Hive ---cannot read database and table in hive
> ---------------------------------------------------------------
>
>                 Key: SPARK-29985
>                 URL: https://issues.apache.org/jira/browse/SPARK-29985
>             Project: Spark
>          Issue Type: Bug
>          Components: Spark Core, Spark Shell
>    Affects Versions: 2.3.2
>            Reporter: lv haiyang
>            Priority: Major
>
> [hadoop@master bin]$ ./beeline
> Beeline version 1.21.2.3.1.4.0-315 by Apache Hive
> beeline> !connect jdbc:hive2://localhost:10016
> Connecting to jdbc:hive2://localhost:10016
> Enter username for jdbc:hive2://localhost:10016: 
> Enter password for jdbc:hive2://localhost:10016: 
> 19/11/21 16:18:39 INFO Utils: Supplied authorities: localhost:10016
> 19/11/21 16:18:39 INFO Utils: Resolved authority: localhost:10016
> 19/11/21 16:18:39 INFO HiveConnection: Will try to open client transport with JDBC Uri: jdbc:hive2://localhost:10016
> Connected to: Spark SQL (version 2.3.2.3.1.4.0-315)
> Driver: Hive JDBC (version 1.21.2.3.1.4.0-315)
> Transaction isolation: TRANSACTION_REPEATABLE_READ
> 0: jdbc:hive2://localhost:10016> use default;
> +---------+--+
> | Result |
> +---------+--+
> +---------+--+
> No rows selected (0.154 seconds)
> 0: jdbc:hive2://localhost:10016> show tables;
> +-----------+------------+--------------+--+
> | database | tableName | isTemporary |
> +-----------+------------+--------------+--+
> +-----------+------------+--------------+--+
> No rows selected (0.048 seconds)
> 0: jdbc:hive2://localhost:10016> use test;
> Error: org.apache.spark.sql.catalyst.analysis.NoSuchDatabaseException: Database 'test' not found; (state=,code=0)
> 0: jdbc:hive2://localhost:10016> show databases;
> +---------------+--+
> | databaseName |
> +---------------+--+
> | default |
> +---------------+--+
> 1 row selected (0.031 seconds)



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org