Query using hive CLI data is visible but if query using HUE no data found for multiple directory hdfs location

Asked Jun 06 '17 at 08:00

Active Jun 06 '17 at 08:29

Viewed 42 times

I created a hive table using

location '/user/hive/test/day=allDataInThisFile'

Hive CLI Query: select * from table; -> works
HUE_Hive Edditor: used the same query -> works

Now I created Hive table using multiple partitioned directories with

location '/user/hive/test'

Here data is contained in following directory structure:

'/user/hive/test/day=monday'
'/user/hive/test/day=tuesday'
'/user/hive/test/day=wednesday'

Hive CLI Query: select * from table; -> works
HUE_Hive Edditor: used the same query -> NOT Working

Can someone please let me know what is the issue here?

edited Jun 06 '17 at 08:29

OneCricketeer

asked Jun 06 '17 at 08:00

voldy

"multiple directory"? – David דודו Markovitz Jun 06 '17 at 08:05
I have edited the question: basically while creating hive table if the location directly points to a hdfs file then no issue, but if i point to a directory, no data is seen on hue – voldy Jun 06 '17 at 08:21
1

Hive CLI doesn't use HiveServer2. Try the same in Beeline – OneCricketeer Jun 06 '17 at 08:27

0 Answers0