HOW TO OPEN THE HIVE TABLE PATH (/user/hive/warehouse/default)

[Kaali babu mandadi]

Hi  please explain how to open the Hive table storage location (/user/hive/warehouse/default/emp)  with example query, thank you. 

[Ashwanth Kumar]

Can you be more specific? What do you mean by open the Hive Table storage? 

If you mean viewing them on HDFS directly, try using the DFS command

$ hadoop dfs -ls /user/hive/warehouse/default/emp 

 

On Thu, Apr 25, 2013 at 7:59 AM, Kaali babu mandadi <babu...@gmail.com> wrote:

Hi  please explain how to open the Hive table storage location (/user/hive/warehouse/default/emp)  with example query, thank you. 

--
You received this message because you are subscribed to the Google Groups "Hadoop Users Group (HUG) Chennai" group.
To unsubscribe from this group and stop receiving emails from it, send an email to chennaihug+...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

--

Ashwanth Kumar / ashwanthkumar.in

[babu mandadi]

thanks for replaying, yes i want to show in my laptop have storage location like part-m-00000, i am running 

       $hadoop fs -ls /user/hive/warehouse/default/emp  but its showing like no such files or directory . please answer this thank you.   

[Ashwanth Kumar]

Did you create a table in hive? 

[babu mandadi]

yes emp table is there in hive

[Ashwanth Kumar]

What is your "hive.metastore.warehouse.dir" value?

[babu mandadi]

could please help how to find out  "hive.metastore.warehouse.dir" value? in my laptop vmware ? you are doing great help to me thank you Ashwanth Kumar. 

[Ashwanth Kumar]

Checkout out the hive-site.xml in your $HIVE_HOME/conf directory

[babu mandadi]

i am using cloud era image file in my Vm, how can we check it $HIVE_HOME/conf directory please explain step by step process sorry for disturbing i am new to Hadoop please understand Thank you. 

[Ashwanth Kumar]

I haven't used Cloudera images before sorry Babu. Checkout the Cloudera documentation for the locations on their VM. 

[babu mandadi]

yes i got it i restarted my system now i got the hive table data path by the following command 

 $hadoop fs -ls /user/hive/warehouse/emp     here no need to define DEFAULT, thank you Ashwanth Kumar you doing a great job here , 

[babu mandadi]

Hi i have success fully executed outer joins in my lap but running inner join its show error like this:

hive> insert overwrite table joins                                                                         

    > select e.eid,e.ename,e.esal,e.sex,d.dname,d.dloc from emp e inner join dept d on (e.eid=d.eid);      

FAILED: Parse Error: line 2:60 mismatched input 'inner' expecting EOF near 'e'

please solve this error also Thank you.

[Ashwanth Kumar]

I guess in Hive INNER JOIN are called just JOIN. 

[babu mandadi]

Yes its work,