Hi, "When I did a -cat, It is not in human readable format" -This is because the file format is specified as orc in your table definition
let me know if this works for you (orc file dump utility) hive --orcfiledump <hdfs-location-of-orc-file> Thanks, Yogendra On Mon, Dec 1, 2014 at 10:49 AM, Somnath Pandeya < somnath_pand...@infosys.com> wrote: > Hi Unmesha, > > > > You can simply do > > Hdfs dfs –cat /user/hive/warehouse/hivemb/delta_0000012_0000012/bucket_00000/* > > > > > And check the content of file. > > > > Thanks > > Somnath > > *From:* unmesha sreeveni [mailto:unmeshab...@gmail.com] > *Sent:* Monday, December 01, 2014 10:31 AM > *To:* User - Hive > *Subject:* How to retriew data from a specific bucket in hive? > > > > > > I created a table in hive > > create table HiveMB > > (EmployeeID Int,FirstName String,Designation String,Salary > Int,Department String) > > clustered by (Department) into 3 buckets > > stored as orc TBLPROPERTIES ('transactional'='true') ; > > > > where my file format is like > > 1,Anne,Admin,50000,A > > 2,Gokul,Admin,50000,B > > 3,Janet,Sales,60000,A > > 4,Hari,Admin,50000,C > > 5,Sanker,Admin,50000,C > > > > and the data went into 3 buckets for department. > > > > When I examined the warehouse , there are 3 buckets > > Found 3 items > > -rwxr-xr-x 3 aibladmin hadoop 252330 2014-11-28 14:46 > /user/hive/warehouse/hivemb/delta_0000012_0000012/bucket_00000 > > -rwxr-xr-x 3 aibladmin hadoop 100421 2014-11-28 14:45 > /user/hive/warehouse/hivemb/delta_0000012_0000012/bucket_00001 > > -rwxr-xr-x 3 aibladmin hadoop 313047 2014-11-28 14:46 > /user/hive/warehouse/hivemb/delta_0000012_0000012/bucket_00002 > > > > How will I be able to retrieve 1 such bucket. > > > > When I did a -cat, It is not in human readable format. > > How can I able to see the data stored into each bucket? > > > > > > -- > > *Thanks & Regards * > > > > *Unmesha Sreeveni U.B* > > *Hadoop, Bigdata Developer* > > *Centre for Cyber Security | Amrita Vishwa Vidyapeetham* > > http://www.unmeshasreeveni.blogspot.in/ > > > > > > **************** CAUTION - Disclaimer ***************** > This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely > for the use of the addressee(s). If you are not the intended recipient, please > notify the sender by e-mail and delete the original message. Further, you are > not > to copy, disclose, or distribute this e-mail or its contents to any other > person and > any such actions are unlawful. This e-mail may contain viruses. Infosys has > taken > every reasonable precaution to minimize this risk, but is not liable for any > damage > you may sustain as a result of any virus in this e-mail. You should carry out > your > own virus checks before opening the e-mail or attachment. Infosys reserves the > right to monitor and review the content of all messages sent to or from this > e-mail > address. Messages sent to or from this e-mail address may be stored on the > Infosys e-mail system. > ***INFOSYS******** End of Disclaimer ********INFOSYS*** > >
