第5期通过案例实战掌握Hive on Spark.pptx

;“Spark纯实战”公益大讲坛- 第5期 ;;《大数据之星-年薪百万大数据纯实战班》- 公开课程; 通过案例实战掌握Hive on Spark;beelineinsert into table testThrift select ordernumber,amount from tbStockDetail??where amount3000; beelineselect * from testThrift;;beelinedrop table testThrift; beelinecreate table testThrift (field1 String , field2 Int); beelineinsert into table testThrift select c.theyear,max(d.sumofamount) from tbDate c join (select a.dateid,a.ordernumber,sum(b.amount) as sumofamount from tbStock a join tbStockDetail??b on a.ordernumber=b.ordernumber group by a.dateid,a.ordernumber )