[CARBONDATA-1096] wrong data show in quering carbontable with timestamp data type from hive

• Type: Bug
• Status: Resolved
• Priority: Trivial
• Resolution: Fixed
• Affects Version/s: 1.2.0
• Component/s: hive-integration
• Assignee: anubhav tarar
• Reporter: anubhav tarar
• Created: 26/May/17 11:28
• Updated: 15/Nov/17 06:06
• Resolved: 12/Oct/17 11:17

Description

start beeline

1.CREATE TABLE ALLDATATYPETEST(ID INT,NAME STRING,SALARY DECIMAL,MARKS DOUBLE,JOININGDATE DATE,LEAVINGDATE TIMESTAMP) STORED BY 'CARBONDATA' ;

2. jdbc:hive2://localhost:10000> LOAD DATA INPATH 'hdfs://localhost:54310/alldatatypetest.csv' into table alldatatypetest;
---------+

Result

---------+
---------+
No rows selected (8.867 seconds)
3: jdbc:hive2://localhost:10000> select * from alldatatypetest;
--------------------------------------------------------------

id

name

salary

marks

joiningdate

leavingdate

--------------------------------------------------------------

1	'ANUBHAV'	200000	100.0	2016-04-14	2016-04-14 15:00:09.0
2	'LIANG'	200000	100.0	2016-04-14	2016-04-14 15:00:09.0

started the hive shell

4.hive> CREATE TABLE ALLDATATYPETEST(ID INT,NAME STRING,SALARY DECIMAL,MARKS DOUBLE,JOININGDATE DATE,LEAVINGDATE TIMESTAMP) ROW FORMAT SERDE 'org.apache.carbondata.hive.CarbonHiveSerDe' STORED AS INPUTFORMAT 'org.apache.carbondata.hive.MapredCarbonInputFormat' OUTPUTFORMAT 'org.apache.carbondata.hive.MapredCarbonOutputFormat' TBLPROPERTIES ('spark.sql.sources.provider'='org.apache.spark.sql.CarbonSource');
OK

5.hive> ALTER TABLE ALLDATATYPETEST SET LOCATION 'hdfs://localhost:54310/opt/carbonStore/default/alldatatypetest';
OK
Time taken: 0.208 seconds

6.hive> SELECT * FROM ALLDATATYPETEST;
OK
1 'ANUBHAV' 200000 100.0 1970-01-01 48255-05-28 04:00:000.0
2 'LIANG' 200000 100.0 1970-01-01 48255-05-28 04:00:000.0
Time taken: 0.137 seconds, Fetched: 2 row(s)

Issue Links

• links to: GitHub Pull Request #967