在Hive中查詢語句往往都要被解析成MapReduce的job進行計算,但是有兩個查詢語句是不走MapReduce的,如下:
1.查詢某張表的所有數據
select * from employees;
結果顯示如下:
hive> select * from employees;
OK
lavimer 15000.0 ["li","lu","wang"] {"k1":1.0,"k2":2.0,"k3":3.0} {"street":"dingnan","city":"ganzhou","num":101}
liao 18000.0 ["liu","li","huang"] {"k4":2.0,"k5":3.0,"k6":6.0} {"street":"dingnan","city":"ganzhou","num":102}
zhang 19000.0 ["xiao","wen","tian"] {"k7":7.0,"k8":8.0,"k8":8.0} {"st......
閱讀全文