½£Ö¸´óÊý¾Ý¨D¨DHIVEѧϰ¾«Òª

µÚ1Õ HiveÈëÃÅ 1 1.1 ʲôÊÇHadoop 1 1.2 ʲôÊÇHive 4 1.3 HiveµÄ¼Ü¹¹ 4 1.4 ѧǰµ¼¶Á 7 1.4.1 ѧϰµÄ»ù±¾ÒªÇó 7 1.4.2 »·¾³×¼±¸ 7 1.5 ±¾ÕÂ×ܽá 8 µÚ2Õ HiveµÄ°²×°²¿Êð 9 2.1 HiveµÄ°²×° 9 2.1.1 Hive³õÌåÑé 9 2.1.2 MySQLµÄ°²×°ºÍÔªÊý¾ÝÅäÖà 12 2.1.3 HiveµÄ·þÎñ²¿Êð 16 2.2 HiveµÄʹÓü¼ÇÉ 24 2.2.1 ³£Óý»»¥ÃüÁî 24 2.2.2 ²ÎÊýÅäÖ÷½Ê½ 25 2.2.3 ³£¼ûÊôÐÔÅäÖà 25 2.3 ±¾ÕÂ×ܽá 27 µÚ3Õ Êý¾Ý¶¨ÒåÓïÑÔ 28 3.1 Êý¾Ý¿âµÄ¶¨Òå 28 3.2 ±íµÄ¶¨Òå 30 3.2.1 ´´½¨±í 30 3.2.2 ±íµÄÆäËû¶¨ÒåÓïÑÔ 34 3.3 ±¾ÕÂ×ܽá 35 µÚ4Õ Êý¾Ý²Ù×÷ÓïÑÔ 36 4.1 Êý¾Ý¼ÓÔØ 36 4.2 Êý¾Ý²åÈë 37 4.2.1 ½«²éѯ½á¹û²åÈë±íÖÐ 37 4.2.2 ½«¸ø¶¨values²åÈë±íÖÐ 37 4.2.3 ½«²éѯ½á¹ûдÈëÄ¿±ê·¾¶ 38 4.3 Êý¾ÝµÄµ¼³öºÍµ¼Èë 38 4.4 ±¾ÕÂ×ܽá 38 µÚ5Õ ²éѯ 39 5.1 Êý¾Ý×¼±¸ 39 5.2 »ù±¾²éѯ 40 5.2.1 select×Ó¾ä¨D¨DÈ«±íºÍÌض¨Áвéѯ 40 5.2.2 ÁбðÃû 42 5.2.3 limit×Ó¾ä 42 5.2.4 order by×Ó¾ä 43 5.2.5 where×Ó¾ä 46 5.2.6 ¹ØϵÔËËã·û 47 5.2.7 Âß¼­ÔËËã·û 49 5.2.8 ËãÊõÔËËã·û 51 5.3 ·Ö×é¾ÛºÏ 52 5.3.1 ¾ÛºÏº¯Êý 52 5.3.2 group by×Ó¾ä 56 5.3.3 having×Ó¾ä 59 5.4 joinÁ¬½Ó 62 5.4.1 joinÁ¬½ÓÓï·¨µÄ¼ò½éÓë±í±ðÃû 62 5.4.2 Êý¾Ý×¼±¸ 65 5.4.3 Á¬½Ó·ÖÀà 66 5.4.4 ¶à±íÁ¬½Ó 71 5.4.5 µÑ¿¨¶ù»ýÁ¬½Ó 73 5.4.6 joinÁ¬½ÓÓëMapReduce³ÌÐò 74 5.4.7 ÁªºÏ£¨union£¦union all£© 75 5.5 ±¾ÕÂ×ܽá 77 µÚ6Õ ×ۺϰ¸ÀýÁ·Ï°Ö®»ù´¡²éѯ 78 6.1 »·¾³×¼±¸ 78 6.2 ¼òµ¥²éѯÁ·Ï° 80 6.3 »ã