You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Hyukjin Kwon (Jira)" <ji...@apache.org> on 2019/12/02 02:48:00 UTC
[jira] [Resolved] (SPARK-29985) Spark integrated Hive ---cannot
read database and table in hive
[ https://issues.apache.org/jira/browse/SPARK-29985?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Hyukjin Kwon resolved SPARK-29985.
----------------------------------
Resolution: Not A Problem
> 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