Mailing-List: contact issues-help@carbondata.incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@carbondata.incubator.apache.org
Date: Fri, 10 Feb 2017 07:05:41 +0000 (UTC)
From: "Vinod Rohilla (JIRA)" <jira@apache.org>
To: issues@carbondata.incubator.apache.org
Message-ID: <JIRA.13039130.1485851696000.46179.1486710341728@Atlassian.JIRA>
In-Reply-To: <JIRA.13039130.1485851696000@Atlassian.JIRA>
References: <JIRA.13039130.1485851696000@Atlassian.JIRA> <JIRA.13039130.1485851696657@jira-lw-us.apache.org>
Subject: [jira] [Closed] (CARBONDATA-689) User unable to create table using
 another database with carbon source.
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
archived-at: Fri, 10 Feb 2017 07:05:46 -0000


     [ https://issues.apache.org/jira/browse/CARBONDATA-689?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Vinod Rohilla closed CARBONDATA-689.
------------------------------------
    Resolution: Fixed

> User unable to create table using another database with carbon source.
> ----------------------------------------------------------------------
>
>                 Key: CARBONDATA-689
>                 URL: https://issues.apache.org/jira/browse/CARBONDATA-689
>             Project: CarbonData
>          Issue Type: Bug
>          Components: spark-integration
>    Affects Versions: 1.0.0-incubating
>         Environment: Spark 2.1
>            Reporter: Vinod Rohilla
>            Priority: Trivial
>         Attachments: Screenshots.png
>
>
> 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.


--
This message was sent by Atlassian JIRA
(v6.3.15#6346)