I have a parquet file with the following three columns
Emp_ID
Emp_Name
Emp_Location
Now I was to create a Hive External Table on top of that file using the below query
CREATE EXTERNAL TABLE if not exists {db_name}.{table_name}
(
`c_Emp_ID` STRING,
`c_Emp_Name` STRING,
`c_Emp_Location` STRING
)
STORED AS PARQUET LOCATION '{File Location in HDFS}'
TBLPROPERTIES ('PARQUET.COMPRESS'='SNAPPY').
The table is being created and I am able to query the table, but all the data are coming as NULL.
Where as if I am using the below create table statement by keeping the column name of the table and parquet file as same, then can see the data properly by querying the table
CREATE EXTERNAL TABLE if not exists {db_name}.{table_name}
(
`Emp_ID` STRING,
`Emp_Name` STRING,
`Emp_Location` STRING
) STORED AS PARQUET LOCATION '{File Location in HDFS}'
TBLPROPERTIES ('PARQUET.COMPRESS'='SNAPPY').
Am I missing some setting? or this is how it is superposed to be?
