Support Questions
Find answers, ask questions, and share your expertise

Tutorial exercise 2 Route of my tables

Solved Go to solution

Tutorial exercise 2 Route of my tables

New Contributor

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

Accepted Solutions

Re: Tutorial exercise 2 Route of my tables

Master Collaborator
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

Re: Tutorial exercise 2 Route of my tables

Master Collaborator
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

New Contributor

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

Master Collaborator
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