question Tutorial exercise 2 Route of my tables in Support Questions

Tutorial exercise 2 Route of my tables

sirchank — Fri, 16 Sep 2022 10:13:42 GMT

Hi, i am trying to review the original access logs table but i can not find it anywhere.

I have completed the tutorial so it must be somewhere, and the find command doesnt work either.

I am looking for the files in the file browser and there is no route

/user/hive/warehouse/original_access_logs
Thank you

Re: Tutorial exercise 2 Route of my tables

Sean — Wed, 13 Apr 2016 14:21:10 GMT

The 2 tables that are created are called 'intermediate_access_logs' and
'tokenized_access_logs' when shown in Hive or Impala. The
intermediate_access_logs table is backed by the raw 'original_access_logs'
file which is copied into HDFS. If you want to view it as a table, it
should still be queryable in Hive at the end of the tutorial. The
underlying data should still be in
/user/hive/warehouse/original_access_logs in HDFS or
/opt/examples/log_files/ on your local filesystem.

Re: Tutorial exercise 2 Route of my tables

sirchank — Wed, 13 Apr 2016 14:33:52 GMT

Thank you very much, and sorry if my questions are too basic, i am just starting.
I am not able to understand where are the files.
If i run the command
hadoop fs -ls /user/hive/warehouse/original_access_logs
the show me the original access logs table, but i can not find in the browser.
i find a hive folder in /usr/lib/hive where are no warehouse folder.

I have no user folder
Than you again

Re: Tutorial exercise 2 Route of my tables

Sean — Wed, 13 Apr 2016 14:40:09 GMT

If you're in the QuickStart VM, it sounds like the browser you're talking
about it is looking at the native Linux filesystem. You can find the file
in this filesystem at /opt/examples/log_files/access.log.2 (or something
like that). The Hive Warehouse directory is in HDFS, which is a separate
filesystem.