Details
-
Bug
-
Status: Resolved
-
Major
-
Resolution: Not A Bug
-
Impala 2.2.4
-
None
-
None
Description
Via the impala shell and beeline, I can:
- Create a db in impala.
- Create a table in that db in impala.
- Can't see that table in Hive.
{{$ impala-shell.sh
Starting Impala Shell without Kerberos authentication
Connected to localhost:21000
Server version: impalad version 2.3.0-cdh5-INTERNAL DEBUG (build b68c8f93dd21fbcc0687effbff15d6663f20350a)
***********************************************************************************
Welcome to the Impala shell. Copyright (c) 2015 Cloudera, Inc. All rights reserved.
(Impala Shell v2.3.0-cdh5-INTERNAL (b68c8f9) built on Fri Aug 21 10:37:01 PDT 2015)
To see a summary of a query's progress that updates in real-time, run 'set
LIVE_PROGRESS=1;'.
***********************************************************************************
[localhost:21000] > create database foo;
Query: create database foo
Fetched 0 row(s) in 0.79s
[localhost:21000] > create table bar (x int);
Query: create table bar (x int)
Fetched 0 row(s) in 0.21s
[localhost:21000] > Goodbye jbapple
$ beeline -u jdbc:hive2://localhost:11050 -n jbapple
scan complete in 1ms
Connecting to jdbc:hive2://localhost:11050
Connected to: Apache Hive (version 1.1.0-cdh5.5.0-SNAPSHOT)
Driver: Hive JDBC (version 1.1.0-cdh5.5.0-SNAPSHOT)
Transaction isolation: TRANSACTION_REPEATABLE_READ
Beeline version 1.1.0-cdh5.5.0-SNAPSHOT by Apache Hive
0: jdbc:hive2://localhost:11050> insert into table foo.bar values (33);
Error: Error while compiling statement: FAILED: SemanticException [Error 10001]: Line 1:18 Table not found 'bar' (state=42S02,code=10001)
0: jdbc:hive2://localhost:11050> use foo;
No rows affected (1.237 seconds)
0: jdbc:hive2://localhost:11050> show tables;
-----------+
| tab_name |
-----------+
-----------+
No rows selected (0.174 seconds)
}}