[jira] (CARBONDATA-689) User unable to create table using another database with carbon source.

[Vinod Rohilla (JIRA)]

Title: Message Title

Vinod Rohilla created an issue   CarbonData / CARBONDATA-689 User unable to create table using another database with carbon source. Issue Type: Bug Affects Versions: 1.1.0-incubating Assignee: Unassigned Attachments: Screenshots.png Components: spark-integration Created: 31/Jan/17 08:34 Environment: Spark 2.1 Priority: Trivial Reporter: Vinod Rohilla 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"); -------- -+ Result -------- -+ -------- -+ No rows selected (0.095 seconds) 0: jdbc:hive2://localhost:10000> use vinod; -------- -+ Result -------- -+ -------- -+ 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"); -------- -+ Result -------- -+ -------- -+ No rows selected (0.093 seconds) " 8: Table does not create on HDFS. Add Comment   This message was sent by Atlassian JIRA (v6.3.15#6346-sha1:dbc023d)