Hi Team, Iam using delimiter /u0001 on Hive. When i insert data on that table i see just data on the first column. Rest of the column are showing as a NULL. Please help find the details below TABLE ::: CREATE TABLE
`man_def_3`(
| | `cntry_cde`
char(3),
| | `cntry_nm`
varchar(45),
| | `iso_cntry_nbr`
char(3),
| | `intl_tran_ind`
char(1),
| | `ofac_prhbt_tran_ind` char(1),
| | `dflt_fin_nwk_cde`
char(5),
| | `eff_dt`
string,
| | `exp_dt`
string,
| | `trnsfrm_dt`
string)
| | ROW FORMAT
DELIMITED
| | FIELDS TERMINATED BY
'\u0001'
| | LINES TERMINATED BY
'\n'
| | STORED AS
INPUTFORMAT
| |
'org.apache.hadoop.mapred.TextInputFormat'
| |
OUTPUTFORMAT
| |
'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
| |
LOCATION
| |
'hdfs://dshdp-dev-cluster/apps/hive/warehouse/neela.db/cntry_def_1' | | TBLPROPERTIES
(
| |
'COLUMN_STATS_ACCURATE'='true',
| |
'numFiles'='1',
| |
'totalSize'='2654',
| | 'transient_lastDdlTime'='1464346137') OUTPUT: select * from man_def_3 ; +------------------------+-----------------------+----------------------------+----------------------------+----------------------------------+-------------------------------+---------------------+---------------------+-------------------------+--+ | cntry_def_3.cntry_cde | cntry_def_3.cntry_nm |
cntry_def_3.iso_cntry_nbr | cntry_def_3.intl_tran_ind |
cntry_def_3.ofac_prhbt_tran_ind | cntry_def_3.dflt_fin_nwk_cde |
cntry_def_3.eff_dt | cntry_def_3.exp_dt |
cntry_def_3.trnsfrm_dt | +------------------------+-----------------------+----------------------------+----------------------------+----------------------------------+-------------------------------+---------------------+---------------------+-------------------------+--+ |
abc
|
NULL
| NULL
|
NULL
|
NULL
|
NULL
|
NULL
| NULL
|
NULL
| |
abc
|
NULL
| NULL
|
NULL
|
NULL
| NULL
|
NULL
|
NULL
| NULL
| |
abc
|
NULL
| NULL
|
NULL
|
NULL
| NULL |
NULL
|
NULL
| NULL
| |
abc
|
NULL
| NULL
|
NULL
|
NULL
| NULL
|
NULL
|
NULL
|
NULL
| |
abc
|
NULL
| NULL
|
NULL
|
NULL
| NULL
|
NULL
| NULL
|
NULL
| Part of Data : abc\u0001su\u0001abc\u0001Y\u0001Y\u0001Test\u00012014-05-30\u00012015-05-30\u00012015-05-30 abc\u0001test1\u0001abc\u0001Y\u0001Y\u0001Test\u00012014-05-30\u00012015-05-30\u00012015-05-30 abc\u0001resh2\u0001abc\u0001Y\u0001Y\u0001Test\u00012014-05-30\u00012015-05-30\u00012015-05-30 abc\u0001sush3\u0001abc\u0001Y\u0001Y\u0001Test\u00012014-05-30\u00012015-05-30\u00012015-05-30 abc\u0001test5\u0001abc\u0001Y\u0001Y\u0001Test\u00012014-05-30\u00012015-05-30\u00012015-05-30 abc\u0001tes6\u0001abc\u0001Y\u0001Y\u0001Test\u00012014-05-30\u00012015-05-30\u00012015-05-30 abc\u0001test52\u0001abc\u0001Y\u0001Y\u0001Test\u00012014-05-30\u00012015-05-30\u00012015-05-30 abc\u0001sh3\u0001abc\u0001Y\u0001Y\u0001Test\u00012014-05-30\u00012015-05-30\u00012015-05-30 abc\u0001s4\u0001abc\u0001Y\u0001Y\u0001Test\u00012014-05-30\u00012015-05-30\u00012015-05-30 abc\u0001s5\u0001abc\u0001Y\u0001Y\u0001Test\u00012014-05-30\u00012015-05-30\u00012015-05-30 abc\u0001s6\u0001abc\u0001Y\u0001Y\u0001Test\u00012014-05-30\u00012015-05-30\u00012015-05-30
... View more
