Hi Users,
I have created dim_date table like below. table created successfully and i then load the data into the dim_date table while i am selecting the table, getting null values.my input file is time.csv file hive> create table dim_date(DateId int,ddate string,Year int,Quarter int,Month_Number_Year int,Month_Number_Of_Quarter int,Week_Number_Of_Year int,Week_Number_Of_Quarter int,Week_Number_Of_Month int,Day_Number_Of_Year int,Day_Number_Of_Quarter int,Day_Number_Of_Month int,Day_Number_Of_Week int,Month_Name string,Month_Name_Abbreviation string,Day_Name string,Day_Name_Abbreviation string)row format delimited fields terminated by '|' stored as textfile; OK Time taken: 0.123 seconds hive> load data local inpath '/usr/local/time.csv' overwrite into table dim_date; Copying data from file:/usr/local/time.csv Copying file: file:/usr/local/time.csv Loading data to table default.dim_date Deleted hdfs://md-aaa1:54310/user/hive/warehouse/dim_date OK Time taken: 0.234 seconds hive> select * from dim_date; NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Please help me on this issue, I have missed anything wrong? Thanks, Prabhu.