Github user steven-qin commented on the issue:
https://github.com/apache/carbondata/pull/1236
@anubhav100
The lastest master branch:
create statement: carbon.sql("create table partsupp2 ( ps_partkey int ,ps_suppkey int ,ps_availqty int , ps_supplycost decimal(15,2) ,ps_comment string ) stored by 'carbondata'")
load statement: carbon.sql("LOAD DATA INPATH '/testdata/partsupp2.csv' INTO TABLE partsupp2 OPTIONS('DELIMITER'='\u0001')")
sql: select * from partsupp2;
ps_partkey | ps_suppkey | ps_availqty | ps_supplycost | ps_comment
------------+------------+-------------+---------------+-------------------------------------------------------------------------------------------------------------------------------------
1 | 2 | 3325 | 7.72 | , even theodolites. regular, final theodolites eat after the carefully pending foxes. furiously regular deposits sleep slyly. carefu
75001 | 2 | 8893 | 1.80 | . blithely regular platelets sleep fluffily ironic, regular platelets. slyly regular deposits nag. packages are furiously according
in spark-shell:
sql: carbon.sql("select * from partsupp2").show
+----------+----------+-----------+-------------+--------------------+
|ps_partkey|ps_suppkey|ps_availqty|ps_supplycost| ps_comment|
+----------+----------+-----------+-------------+--------------------+
| 1| 2| 3325| 771.64|, even theodolite...|
| 75001| 2| 8893| 179.82|. blithely regula...|
+----------+----------+-----------+-------------+--------------------+
The pr-1236 branch:
git fetch origin pull/1236/head:pr-1236
sql: select * from partsupp2;
ps_partkey | ps_suppkey | ps_availqty | ps_supplycost | ps_comment
------------+------------+-------------+---------------+-------------------------------------------------------------------------------------------------------------------------------------
1 | 2 | 3325 | 771.64 | , even theodolites. regular, final theodolites eat after the carefully pending foxes. furiously regular deposits sleep slyly. carefu
75001 | 2 | 8893 | 179.82 | . blithely regular platelets sleep fluffily ironic, regular platelets. slyly regular deposits nag. packages are furiously according
---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at
[hidden email] or file a JIRA ticket
with INFRA.
---
Locked
