|
I try to create the table in default database it was successfully created successfully and showing same in HDFS but when I create a new database(vinod) and inside I try to create the same table then as per the log it's created successfully but the table does not exist in HDFS(under vinod database).
Steps to Reproduces:
1: User should be default database.
2: Create table by using the following command:
" CREATE TABLE table11 (ID Int, date Timestamp, country String, name String, phonetype String, serialname String, salary Int) USING org.apache.spark.sql.CarbonSource OPTIONS("tableName"="table11"); "
3: Table created successfully in the default database.
4: Create database vinod;
5: Use vinod;
6: Create the same table:
" CREATE TABLE table11 (ID Int, date Timestamp, country String, name String, phonetype String, serialname String, salary Int) USING org.apache.spark.sql.CarbonSource OPTIONS("tableName"="table11"); "
7: Tables shows created as per log.
" 0: jdbc:hive2://localhost:10000> CREATE TABLE table11 (ID Int, date Timestamp, country String, name String, phonetype String, serialname String, salary Int) USING org.apache.spark.sql.CarbonSource OPTIONS("tableName"="table11");
--------
--------
No rows selected (0.095 seconds)
0: jdbc:hive2://localhost:10000> use vinod;
--------
--------
No rows selected (0.02 seconds)
0: jdbc:hive2://localhost:10000> CREATE TABLE table11 (ID Int, date Timestamp, country String, name String, phonetype String, serialname String, salary Int) USING org.apache.spark.sql.CarbonSource OPTIONS("tableName"="table11");
--------
--------
No rows selected (0.093 seconds)
"
8: Table does not create on HDFS.
|
Locked
