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
> Thank you for your reply
> My DDL a
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
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.
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 ow
