I am just test Now I can display query result ,where year =2013 When I do not specify the where clause condition, it is not displaying data. I must say exactly specify the partition in the where clause condition in order to have data show
2013/10/17 kun yan <yankunhad...@gmail.com> > 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 > > -- 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
