Unable to view the retail_db tables from local file system


#1

ls -ltr /data/retail_db

drwxr-xr-x 2 root root 4096 Feb 20 2017 products
drwxr-xr-x 2 root root 4096 Feb 20 2017 orders
drwxr-xr-x 2 root root 4096 Feb 20 2017 order_items
drwxr-xr-x 2 root root 4096 Feb 20 2017 departments
drwxr-xr-x 2 root root 4096 Feb 20 2017 customers
drwxr-xr-x 2 root root 4096 Feb 20 2017 categories
[rachit92@gw03 ~]$ cd orders
-bash: cd: orders: No such file or directory
[rachit92@gw03 ~]$ cd categories
-bash: cd: categories: No such file or directory
[rachit92@gw03 ~]$

I am unable to view the orders table from the retail_db which is stored in the local file system. Kindly let me know if I’m missing anything.


Sign up for our state of the art Big Data cluster for hands on practice as developer. Cluster have Hadoop, Spark, Hive, Sqoop, Kafka and more.



#2

Hi @rachit92,
Use the below command.
For orders : cd /data/retail_db/orders
For Categories : cd /data/retail_db/categories