advise for dim table

[Fawze Abujaber]

Hi Community,

I have a process importing file from vertica to hadoop and i create an
impala table on it, i start see weird behaviour where 0 INT value are
missing in the table, when i create the table and changing the column to
STRING is see the record.

*** The table definition in vertica is INT

Any quick insight.



hdfs dfs -cat /fawze/dim_agent_status_v2p/temp_data_8240.txt
0       Login
1       Logout
2       Online
4       Away
3       Back Soon


CREATE TABLE default.analytics_dim_agent_status_v2p (
  state_id INT,
  state_name STRING
)
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t'
WITH SERDEPROPERTIES ('field.delim'='\t', 'serialization.format'='\t')
STORED AS TEXTFILE
LOCATION '/fawze/dim_agent_status_v2p'


select * from analytics_dim_agent_status_v2p

1       Logout
2       Online
4       Away
3       Back Soon
Fetched 4 row(s) in 0.01s

===============

CREATE TABLE default.analytics_dim_agent_status_v3p (
  state_id STRING,
  state_name STRING
)
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t'
WITH SERDEPROPERTIES ('field.delim'='\t', 'serialization.format'='\t')
STORED AS TEXTFILE
LOCATION '/fawze//analytics_dim_agent_status_v2p'


 select * from analytics_dim_agent_status_v3p

0       Login
1       Logout
2       Online
4       Away
3       Back Soon
Fetched 5 row(s) in 0.11s

-- 
Take Care
Fawze Abujaber