You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "lv haiyang (Jira)" <ji...@apache.org> on 2019/11/21 08:58:00 UTC
[jira] [Created] (SPARK-29985) Spark integrated Hive ---cannot read
database and table in hive
lv haiyang created SPARK-29985:
----------------------------------
Summary: 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
[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