Many tools are using SQL-like query languages, Refer to the documentation for the Hive and Presto languages. Presto Language docs
Added by Todd S.
Step 1
Sure! To generate a step-by-step answer regarding the use of SQL-like query languages in Hive and Presto, we can follow these steps: Show more…
Show all steps
Your feedback will help us improve your experience
Haricharan Gupta and 99 other AP CS educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
What is the use of the query language Pig in Hadoop?
Haricharan G.
Task 4 (5 marks) Implementation of a data warehouse as a collection of external tables in Hive Download the following files: author.tbl, item.tbl, dbcreate.sql Use an editor to examine the contents of *.tbl files. The files contain synthetic data extracted from the relational tables. A file dbcreate.sql contains CREATE TABLE statements used to create the relational tables with the synthetic data. Transfer the files author.tbl, item.tbl into HDFS (1) Implement HQL script solution4.hql to create the external tables that provide The external tables must overlap on the files transferred to HDFS in the previous step. It is recommended to use CREATE TABLE statements included in a file dbcreate.sql to create a file solution4.hql. (2) Include into solution4.hql script SELECT statements that list the total number of rows in each table, the total number of rows in both tables, and the first 3 rows. When ready, use a command line interface beeline to process a script solution4.hql and to save a report from processing in a file solution4.pdf. If the processing of the file returns errors, then you must eliminate the errors! Processing of your script must return NO ERRORS! A solution with errors is worth no marks! Deliverables: A file solution4.pdf with a report from processing of HQL script solution4.hql. The report MUST NOT include any errors, and the report must list all SQL statements processed.
Akash M.
PROVIDE the SQL query that solves the problem 9) List all information for members that are located in TN and have a balance greater than $10. (w3schools -> SQL And & Or) 10) List the title of the movies that are either action or drama. (w3schools -> SQL And & Or) 11) List only those members whose last names start with the letter 'M'. (w3schools -> SQL Like and SQL Wildcards) 12) List all return dates but do not display the column label [Detail_ReturnDate] - instead display a label of 'Returned' (w3schools -> SQL Alias) 13) Return the total of rent fee and daily late fee AS TOTALoneDayLate for every price code (w3schools -> SQL Alias) 14) List all video numbers for movie numbers 1235, 1237 and 1245 - use the IN keyword (w3schools -> IN) 15) List the member number for all members who rented a video on March 2, 2018. {Working with dates can be very tricky. In this database, the date datatype is simple – month -day-year. In Oracle, you will search using this format: ‘dd-mmm-yyyy’ quote marks required: = ‘02-Mar-2018’ In Access, you use the # key: = #02-Mar-2018# {Access will also allow #3/2/2018#}}
Recommended Textbooks
Computer Science and Information Technology
Introduction to Programming Using Python
Computer Science - An Overview
Transcript
18,000,000+
Students on Numerade
Trusted by students at 8,000+ universities
Watch the video solution with this free unlock.
EMAIL
PASSWORD