Flash Sale: Flat 70% + Addl. 25% Off on all Courses | Use Coupon DS25 in Checkout | Offer Expires In

  Enroll Now

Hive Project - Process the NSE data - Step 1

Step1 - Exploring and creating a hive table

As part of this project, we will learn to analyze the stock data using Hive.

The data for this project is located at /data/NYSE_daily in HDFS. Please take a look at the file. You will notice that each line in the file represents a record having tab-separated fields. The name of the fields along with the data types are in the following order:

stockexchange STRING, symbol STRING, ymd STRING, price_open FLOAT, price_high FLOAT, price_low FLOAT, price_close FLOAT, volume INT, price_adj_close FLOAT

INSTRUCTIONS
  1. Please copy this folder /data/NYSE_daily in your HDFS home directory.
  2. Create a database corresponding to your cloudxlab username
  3. Create a table with the name nyse in your database corresponding to the various fields.

No hints are availble for this assesment

Answer is not availble for this assesment


Note - Having trouble with the assessment engine? Follow the steps listed here

Loading comments...