Comments on: Partitioning In Hive https://acadgild.com/blog/partitioning-in-hive/ Learn. Do. Earn. Thu, 25 Aug 2016 12:12:23 +0000 hourly 1 https://wordpress.org/?v=4.5.3 By: Prafull https://acadgild.com/blog/partitioning-in-hive/#comment-3095 Mon, 11 Jul 2016 18:06:29 +0000 http://acadgild.com/blog/?p=329#comment-3095 In static partitioning example, i can’t see country data in sample data, like its there in dynamic partitioning example. Is that a flaw?

]]> By: mak https://acadgild.com/blog/partitioning-in-hive/#comment-616 Sat, 16 Jan 2016 21:35:56 +0000 http://acadgild.com/blog/?p=329#comment-616 Hi team,

need to how we can achieve correlated query functionality in hive, as i m not able to use correlated query.

i have a sql query and need to re-write it using hive

SELECT M.MODELNAME,(SELECT SALE FROM CAR WHERE MONTH=’Jan’ AND MODELID=M.MODELID) AS JAN_SALE,
(SELECT SALE FROM CAR WHERE MONTH=’Feb’ AND MODELID=M.MODELID) AS FEB_SALE,
(SELECT SALE FROM CAR WHERE MONTH=’Mar’ AND MODELID=M.MODELID) AS MAR_SALE
FROM MODEL M INNER JOIN CAR C ON(C.MODELID=M.MODELID);

Please suggest

]]> By: Hamraj https://acadgild.com/blog/partitioning-in-hive/#comment-222 Sun, 06 Dec 2015 14:21:32 +0000 http://acadgild.com/blog/?p=329#comment-222 Hey! It impressed me a lot i am shifting from SQL to HIVE….!

]]>