Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Tutorial exercise 2 Route of my tables

avatar
Explorer

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

 

1 ACCEPTED SOLUTION

avatar
Guru
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.

View solution in original post

3 REPLIES 3

avatar
Guru
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.

avatar
Explorer

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

avatar
Guru
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.