Re: Unable to pick data from subdirectories into hive table in CDH 5.3.3

2016-05-23 Thread Gabriel Balan
ster, I’m yet to try on other CDH versions. *Thanks & Regards,* *Abhishek Dubey*** *From:*Mich Talebzadeh [mailto:mich.talebza...@gmail.com] *Sent:* Friday, May 20, 2016 1:22 AM *To:* user *Subject:* Re: Unable to pick data from subdirectories into hive table in CDH 5.3.3 agreed but

RE: Unable to pick data from subdirectories into hive table in CDH 5.3.3

2016-05-20 Thread Abhishek Dubey
shek Dubey From: Mich Talebzadeh [mailto:mich.talebza...@gmail.com] Sent: Friday, May 20, 2016 1:22 AM To: user Subject: Re: Unable to pick data from subdirectories into hive table in CDH 5.3.3 agreed but it still needs to know where the hive top node directory starts from, which is normally u

Re: Unable to pick data from subdirectories into hive table in CDH 5.3.3

2016-05-19 Thread Mich Talebzadeh
agreed but it still needs to know where the hive top node directory starts from, which is normally under ../../ warehouse Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw

Re: Unable to pick data from subdirectories into hive table in CDH 5.3.3

2016-05-19 Thread Al Pivonka
Read about hive partitions and bucketing. Since your location has multiple directories, Hive needs to know how to traverse them.. Hope this helps. On May 19, 2016 5:51 AM, "Abhishek Dubey" wrote: > Hi, > > > > In hdfs I have a directory structure like this. > > /user/hdfs/Data/Data1/File1 > > /u

Re: Unable to pick data from subdirectories into hive table in CDH 5.3.3

2016-05-19 Thread Mich Talebzadeh
Hi, I am not familiar with CDH, but in a default set -up, the hive directory is under hdfs://https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw * http://talebzadehmich.wordpress.com