10-25. Write two HIVE queries, the first to create a PRODUCT table with fields ProdID, Name,...

Question

Question

10-25. Write two HIVE queries, the first to create a PRODUCT table with fields ProdID, Name, Seller, Price; the sec- ond to l

engineering Computer-Science

Add a comment Improve this question Transcribed image text

Answer 1

Answer #1

1. To Create Table:-

create table if not exists PRODUCT (ProdID int, Name string, Seller string, Price float) row format delimited fields terminated by ',' ;

Output:

INFO : Executing command (queryId=hive_20200129020612_e6cc96a-1243-4843-9689-ace442b99f78): create table if not exists PRODUC

2. Assuming that the file that is to be loaded int the table is product.csv and it is present in the downloads folder of my computer it's location will be "/Users/my_name/Downloads/product.csv". So the query to load data will be:-

LOAD DATA INPATH '/Users/my_name/Downloads/product.csv' INTO TABLE PRODUCT;

Note:- file product.csv will get automatically deleted after loading data into the PRODUCT table.

Add a comment

Answer 2

Similar Homework Help Questions

(3.5 Marks) Create the table CAR and create the fields with primary key Field Name Data...

(3.5 Marks) Create the table CAR and create the fields with primary key Field Name Data type Size Constraint A2.1 Name Model Price MED Varchar2 25 Not nul Number 10 Primary key Number 10,2 Date Write a SQL Query to display all car details from the "CAR" table and display the Name in lowercase in a new column with the column name as Newname. (3.5 Marks) A2.2 Name Model Price MFD Mazda 456 7760.2523-12-2018 Kia 127 4050.1 30-11-2019 Toyota 443...
NEED THE SQL QUERIES ASAP PLEASE(LIKE 1 HOUR) THE ONES WITH ID ARE PRIMARY KEYS OR...

NEED THE SQL QUERIES ASAP PLEASE(LIKE 1 HOUR) THE ONES WITH ID ARE PRIMARY KEYS OR FOREIGN etc Customer [ CustID, LastName, FirstName, Address, City, State, Zip, Phone, Fax, Email] Product [ ProdID, Description, Color, Size, Pack] Sales [ TransID, CustID, ProdID, Price, Quantity, Amount] Write SQL statement to produce a list of unique products and their prices from the Sales table. Please ensure that the products do not repeat. Write an SQL statement to list ProdID and Description for...
1. Create a table that will hold the data in avgprice kwh state.csv. This .csv file...

1. Create a table that will hold the data in avgprice kwh state.csv. This .csv file contains the annual data from 1990-2012 on the average energy price per kilowatt hour (KwH) by state and provider type. Implement the following queries: • Print each row that has Tennessee as state, order the result by year in descending order. • Print the average residential, commercial, industrial, and transportation price for the state of Texas from the year 1990-2012. 2. Create the tables...

Create a table tHW2_1_xxxx with the following fields and their data types (id:int, auto increment, Name:...

Create a table tHW2_1_xxxx with the following fields and their data types (id:int, auto increment, Name: varchar(10), birthday: date, annual_salary: float, bno: varchar(8)), where id is primary key and bno is a foreign key to the branchno column of Branch table in the dreamhome database. All fields cannot be null. then insert five records into your tHW2_1_xxxx table. All the name, birthday, should be different.
Use MS Access software to build tables, as well as write, and execute queries. Submit the...

Use MS Access software to build tables, as well as write, and execute queries. Submit the database and screenshots of all tables and queries. Step by step snapshots included. Don't want queries. Just process of creating this data step by step in Access. Create your own data. Ensure the data will test all criteria and prove all sorts worked as required. Be sure that all tables and queries have descriptive names. “Query 1” and “Step 1” are examples of poor...
4. Write SQL data definition commands for each of the following queries: a. How would you add an attribute, Class, to the Student table? b. How would you remove the Registration table? c. How would you change the FacultyName field from 25 characters

Problems and Exercises 1 through 9 are based on the dass scheduling 3NF relations along with some sample data shown in Figure 6-11. Not shown in this figure are data for an ASSIGNMENT relation, which represents a many-to-many relationship between faculty and sections.4. Write SQL data definition commands for each of the following queries:a. How would you add an attribute, Class, to the Student table?b. How would you remove the Registration table?c. How would you change the FacultyName field from...

Create a table called "tblActor". The tblActor should have the following fields (name, description, dob, country,...

Create a table called "tblActor". The tblActor should have the following fields (name, description, dob, country, image) Paste the SQL commands you wrote to create the table: Paste a screen shot shows the created table in MyPHPAdmin: Populate the table "tblActor" with information about your favorite four actors. Paste a screen shot shows the data you added to the "tblActor": Write a PHP code that read the data from the "tblActor" table, and generate a JSON response similar to the...
Microsoft Access 0 database name should be the broad name of what will be inside it....

Microsoft Access 0 database name should be the broad name of what will be inside it. If I were creating a database on the history of the Pittsburgh Steeler Coaches I would call mine SteelerCoaches.accdb, for example. A. Design one table with at least a. 6 Fields (can have more, but not more than 10) b. Correct datatypes for your fields c. Property changes appropriate to the fields. Have all Field names with more than one word have no spaces...
C# Language please. Create an “Employee” class with six fields: first name, last name, workID, yearStartedWked,...

C# Language please. Create an “Employee” class with six fields: first name, last name, workID, yearStartedWked, initSalary, and curSalary. It includes constructor(s) and properties to initialize values for all fields (curSalary is read-only). It also includes a calcCurSalary function that assigns the curSalary equal to initSalary. Create a “Worker” classes that are derived from Employee class.  In Worker class, it has one field, yearWorked. It includes constructor(s) and properties. It also includes two functions: first, calcYearWorked function, it takes...

For C++ Create a student structure that has fields for first name, last name, hometown, state,...

For C++ Create a student structure that has fields for first name, last name, hometown, state, year in college and major. Keep the number of students to a reasonabe level. Place each structure into an array sorted by last name and within last name, by first name. Read the student information from a file and print the sorted array to the screen and then to an output file. I was using the code below to guide me but it keeps...

10-25. Write two HIVE queries, the first to create a PRODUCT table with fields ProdID, Name,...

Homework Answers

Add Answer to:
10-25. Write two HIVE queries, the first to create a PRODUCT table with fields ProdID, Name,...

Post as a guest

Earn Coins

(3.5 Marks) Create the table CAR and create the fields with primary key Field Name Data...

NEED THE SQL QUERIES ASAP PLEASE(LIKE 1 HOUR) THE ONES WITH ID ARE PRIMARY KEYS OR...

1. Create a table that will hold the data in avgprice kwh state.csv. This .csv file...

Create a table tHW2_1_xxxx with the following fields and their data types (id:int, auto increment, Name:...

Use MS Access software to build tables, as well as write, and execute queries. Submit the...

4. Write SQL data definition commands for each of the following queries: a. How would you add an attribute, Class, to the Student table? b. How would you remove the Registration table? c. How would you change the FacultyName field from 25 characters

Create a table called "tblActor". The tblActor should have the following fields (name, description, dob, country,...

Microsoft Access 0 database name should be the broad name of what will be inside it....

C# Language please. Create an “Employee” class with six fields: first name, last name, workID, yearStartedWked,...

For C++ Create a student structure that has fields for first name, last name, hometown, state,...

10-25. Write two HIVE queries, the first to create a PRODUCT table with fields ProdID, Name,...

Homework Answers

Add Answer to: 10-25. Write two HIVE queries, the first to create a PRODUCT table with fields ProdID, Name,...

Post as a guest

Earn Coins

Add Answer to:
10-25. Write two HIVE queries, the first to create a PRODUCT table with fields ProdID, Name,...