Valid 70-775 Dumps shared by ExamDiscuss.com for Helping Passing 70-775 Exam! ExamDiscuss.com now offer the newest 70-775 exam dumps, the ExamDiscuss.com 70-775 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com 70-775 dumps with Test Engine here:
DRAG DROP You have a text file named Data/examples/product.txt that contains product information. You need to create a new Apache Hive table, import the product information to the table, and then read the top 100 rows of the table. Which four code segments should you use in sequence? To answer, move the appropriate code segments from the list of code segments to the answer area and arrange them in the correct order. Select and Place:
Correct Answer:
Explanation/Reference: Explanation: val sqlContext = new org.apache.spark.sql.hive.HiveContext(sc) sqlContext.sql("CREATE TABLE IF NOT EXISTS productid INT, productname STRING)" sqlContext.sql("LOAD DATA LOCAL INPATH 'Data/examples/product.txt' INTO TABLE product") sqlContext.sql("SELECT productid, productname FROM product LIMIT 100").collect().foreach (println) References: https://www.tutorialspoint.com/spark_sql/spark_sql_hive_tables.htm
