Mailing-List: contact issues-help@carbondata.incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@carbondata.incubator.apache.org
Date: Wed, 19 Oct 2016 10:46:58 +0000 (UTC)
From: "Prabhat Kashyap (JIRA)" <jira@apache.org>
To: issues@carbondata.incubator.apache.org
Message-ID: <JIRA.13013471.1476873981000.27208.1476874018324@Atlassian.JIRA>
In-Reply-To: <JIRA.13013471.1476873981000@Atlassian.JIRA>
References: <JIRA.13013471.1476873981000@Atlassian.JIRA> <JIRA.13013471.1476873981879@arcas>
Subject: [jira] [Created] (CARBONDATA-326) Creates wrong table on 'create
 table like'
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
archived-at: Wed, 19 Oct 2016 10:47:03 -0000

Prabhat Kashyap created CARBONDATA-326:
------------------------------------------

             Summary: Creates wrong table on 'create table like' 
                 Key: CARBONDATA-326
                 URL: https://issues.apache.org/jira/browse/CARBONDATA-326
             Project: CarbonData
          Issue Type: Bug
            Reporter: Prabhat Kashyap


I'm trying to create a table like my old table but it is not creating as expected.

0: jdbc:hive2://localhost:10000> CREATE TABLE mainTable(id INT, name STRING) STORED BY 'carbondata';
+---------+--+
| Result  |
+---------+--+
+---------+--+
No rows selected (0.206 seconds)
0: jdbc:hive2://localhost:10000> DESC mainTable;
+-----------+------------+----------+--+
| col_name  | data_type  | comment  |
+-----------+------------+----------+--+
| name      | string     |          |
| id        | bigint     |          |
+-----------+------------+----------+--+
2 rows selected (0.056 seconds)


Above one is my mainTable and I wants to create copiedTable from it but everytime it is show something like:

0: jdbc:hive2://localhost:10000> CREATE TABLE copiedTable LIKE mainTable;
+---------+--+
| result  |
+---------+--+
+---------+--+
No rows selected (0.101 seconds)
0: jdbc:hive2://localhost:10000> DESC copiedTable;
+-----------+----------------+--------------------+--+
| col_name  |   data_type    |      comment       |
+-----------+----------------+--------------------+--+
| col       | array<string>  | from deserializer  |
+-----------+----------------+--------------------+--+
1 row selected (0.022 seconds)

0: jdbc:hive2://localhost:10000> LOAD DATA LOCAL INPATH 'hdfs://localhost:54310/user/hduser/datafiles/data.csv' INTO TABLE copiedTable OPTIONS('DELIMITER'=',');
Error: java.lang.RuntimeException: Data loading failed. table not found: knoldus.copiedtable (state=,code=0)

0: jdbc:hive2://localhost:10000> select * from copiedTable;
+------+--+
| col  |
+------+--+
+------+--+
No rows selected (0.11 seconds)


--
This message was sent by Atlassian JIRA
(v6.3.4#6332)