Thank you for your reply My DDL as follow first step CREATE EXTERNAL TABLE IF NOT EXISTS data( ROWKEY STRING, STATION INT, MONTH INT, DAY INT, HOUR INT, MINUTE INT, ) PARTITIONED BY (YEAR INT) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' STORED AS TEXTFILE;
seconde step ALTER TABLE data ADD PARTITION(year = 2013) LOAD DATA INPATH '1998.txt' INTO TABLE data PARTITION(YEAR=2013); 2013/10/17 Nitin Pawar <nitinpawar...@gmail.com> > 1) there is no data loaded in table > 2) there is no data matching to your where clause condition > 3) there is mismatch in where condition > > what you can do is > run select * from data limit 10; > this will show you if you got any data in the table. Other way to do the > same is hdfs -ls on table directory. > > Once you are sure there is data in the table, please share your create > table ddl > > > On Thu, Oct 17, 2013 at 8:18 AM, kun yan <yankunhad...@gmail.com> wrote: > >> Hi all >> By hive query to display， only field that does not show any results may >> be what causes it? >> the sql like follow >> select * from data where year=2013; >> hive version is 0.10 >> >> -- >> >> In the Hadoop world, I am just a novice, explore the entire Hadoop >> ecosystem, I hope one day I can contribute their own code >> >> YanBit >> yankunhad...@gmail.com >> >> > > > -- > Nitin Pawar > -- In the Hadoop world, I am just a novice, explore the entire Hadoop ecosystem, I hope one day I can contribute their own code YanBit yankunhad...@gmail.com
