1 / 18

Process of Hive in HDFS

This PPT is about that How data process in hive using SQL command. Using hive we are creating database, can see databases list, creating table in particular database. importing data from HDFS to hive using command, how we are dealing with queries in bigdata specially in hive.

prwatechinstitution
Download Presentation

Process of Hive in HDFS

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. HADOOP - HIVE PrwatechInstituion

  2. Starting With Hive • First of All We have to Format namenode and start Hadoop Daemons • $hadoopnamenode –format • $start-all.sh • $jps • JPS command is check your daemons are start or not. • Then Start Hive. • $hive

  3. 1) Create database

  4. 2) Show Databases

  5. 3) Then use database, which one your are created

  6. 4) Create Table

  7. 5) Create a hdfs directory

  8. 6) Check your table metadata/scema.

  9. 7) Load data into Table

  10. 8) Count a data from your Table

  11. 9) Create External Table

  12. 10) Overwrite a Data of another table

  13. 11-A) Set this for partition of hive table

  14. 11-B

  15. 11-C) for Bucketing

  16. 12) If you want to Delete table then use this query

  17. 13) Show all Tables of current Database

  18. Thank You

More Related