[jira] [Created] (CARBONDATA-422) [Bad Records]Select query failed with "NullPointerException" after data-load with options as MAXCOLUMN and BAD_RECORDS_ACTION

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[jira] [Created] (CARBONDATA-422) [Bad Records]Select query failed with "NullPointerException" after data-load with options as MAXCOLUMN and BAD_RECORDS_ACTION

Akash R Nilugal (Jira)
SOURYAKANTA DWIVEDY created CARBONDATA-422:
----------------------------------------------

             Summary: [Bad Records]Select query failed with "NullPointerException" after data-load with options as MAXCOLUMN and BAD_RECORDS_ACTION
                 Key: CARBONDATA-422
                 URL: https://issues.apache.org/jira/browse/CARBONDATA-422
             Project: CarbonData
          Issue Type: Bug
          Components: data-query
    Affects Versions: 0.1.1-incubating
         Environment: 3 node Cluster
            Reporter: SOURYAKANTA DWIVEDY
            Priority: Minor


Description : Select query failed with "NullPointerException" after data-load with options as MAXCOLUMN and BAD_RECORDS_ACTION
Steps:
1. Create table
2. Load data into table with BAD_RECORDS_ACTION option [ Create Table -- columns -9 ,CSV coulmn - 10 , Header - 9]
3. Do select * query ,it will pass
 4. Then Load data into table with BAD_RECORDS_ACTION and MAXCOLUMN option [ Create Table -- columns -9 ,CSV coulmn - 10 , Header - 9,MAXCOLUMNS -- 9]
5. Do select * query ,it will fail with "NullPointerException"

Log :-
-------
0: jdbc:hive2://ha-cluster/default> create table emp3(ID int,Name string,DOJ timestamp,Designation string,Salary double,Dept string,DOB timestamp,Addr string,Gender string) STORED BY 'org.apache.carbondata.format';
+---------+--+
| result |
+---------+--+
+---------+--+
No rows selected (0.589 seconds)
0: jdbc:hive2://ha-cluster/default> LOAD DATA inpath 'hdfs://hacluster/chetan/emp11.csv' into table emp3 options('DELIMITER'=',', 'QUOTECHAR'='"','FILEHEADER'='ID,Name,DOJ,Designation,Salary,Dept,DOB,Addr,Gender', 'BAD_RECORDS_ACTION'='FORCE');
+---------+--+
| Result |
+---------+--+
+---------+--+
No rows selected (2.415 seconds)
0: jdbc:hive2://ha-cluster/default> select * from emp3;
+-------+-------+-------+--------------+----------+-------+-------+------------+---------+--+
| id | name | doj | designation | salary | dept | dob | addr | gender |
+-------+-------+-------+--------------+----------+-------+-------+------------+---------+--+
| NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| 1 | AAA | NULL | Trainee | 10000.0 | IT | NULL | Pune | Male |
| 2 | BBB | NULL | SE | 30000.0 | NW | NULL | Bangalore | Female |
| 3 | CCC | NULL | SSE | 40000.0 | DATA | NULL | Mumbai | Female |
| 4 | DDD | NULL | TL | 60000.0 | OPER | NULL | Delhi | Male |
| 5 | EEE | NULL | STL | 80000.0 | MAIN | NULL | Chennai | Female |
| 6 | FFF | NULL | Trainee | 10000.0 | IT | NULL | Pune | Male |
| 7 | GGG | NULL | SE | 30000.0 | NW | NULL | Bangalore | Female |
| 8 | HHH | NULL | SSE | 40000.0 | DATA | NULL | Mumbai | Female |
| 9 | III | NULL | TL | 60000.0 | OPER | NULL | Delhi | Male |
| 10 | JJJ | NULL | STL | 80000.0 | MAIN | NULL | Chennai | Female |
| NULL | Name | NULL | Designation | NULL | Dept | NULL | Addr | Gender |
+-------+-------+-------+--------------+----------+-------+-------+------------+---------+--+
12 rows selected (0.418 seconds)
0: jdbc:hive2://ha-cluster/default> LOAD DATA inpath 'hdfs://hacluster/chetan/emp11.csv' into table emp3 options('DELIMITER'=',', 'QUOTECHAR'='"','FILEHEADER'='ID,Name,DOJ,Designation,Salary,Dept,DOB,Addr,Gender','MAXCOLUMNS'='9', 'BAD_RECORDS_ACTION'='FORCE');
+---------+--+
| Result |
+---------+--+
+---------+--+
No rows selected (1.424 seconds)
0: jdbc:hive2://ha-cluster/default> select * from emp3;
Error: java.io.IOException: java.lang.NullPointerException (state=,code=0)
0: jdbc:hive2://ha-cluster/default>





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