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) |
Free forum by Nabble | Edit this page |