对于外部表而言，Because it's external, Hive doesn't assume it owns the data. Therefore, dropping the external table doesn't delete the data, although the metadata for the table will be deleted(即外部表的metadata与real data是分开存放的). Let's 瞧瞧看： hive> set hive.cli.print.current.db = true; hive (default)> use economy; OK Time taken: 3.334 seconds hive (economy)> show tables; OK stocks Time taken: 0.317 seconds hive (economy)> describe database economy; OK economy stock economy from different countries hdfs://localhost:9000/home/landen/UntarFile/hive-0.10.0/user/hive/warehouse/economy.db（外部表stock所在数据库economy） Time taken: 0.046 seconds hive (economy)> 在让我们瞧瞧hdfs文件系统中的目录: landen@landen-Lenovo:~/UntarFile/hadoop-1.0.4$ bin/hadoop fs -ls / Found 2 items drwxr-xr-x - landen supergroup 0 2013-03-27 18:48 /data drwxr-xr-x - landen supergroup 0 2013-03-27 15:55 /home 现在查看外部表stocks中的数据，如下： landen@landen-Lenovo:~/UntarFile/hadoop-1.0.4$ bin/hadoop fs -ls /data/stocks Found 26 items -rw-r--r-- 1 landen supergroup 51579797 2013-03-27 18:48 /data/stocks/NASDAQ_daily_prices_A.csv -rw-r--r-- 1 landen supergroup 21998523 2013-03-27 18:48 /data/stocks/NASDAQ_daily_prices_B.csv -rw-r--r-- 1 landen supergroup 52040124 2013-03-27 18:48 /data/stocks/NASDAQ_daily_prices_C.csv -rw-r--r-- 1 landen supergroup 15212044 2013-03-27 18:48 /data/stocks/NASDAQ_daily_prices_D.csv -rw-r--r-- 1 landen supergroup 19171632 2013-03-27 18:48 /data/stocks/NASDAQ_daily_prices_E.csv -rw-r--r-- 1 landen supergroup 22071274 2013-03-27 18:48 /data/stocks/NASDAQ_daily_prices_F.csv -rw-r--r-- 1 landen supergroup 12425739 2013-03-27 18:48 /data/stocks/NASDAQ_daily_prices_G.csv -rw-r--r-- 1 landen supergroup 16278921 2013-03-27 18:48 /data/stocks/NASDAQ_daily_prices_H.csv -rw-r--r-- 1 landen supergroup 21628863 2013-03-27 18:48 /data/stocks/NASDAQ_daily_prices_I.csv -rw-r--r-- 1 landen supergroup 6045097 2013-03-27 18:48 /data/stocks/NASDAQ_daily_prices_J.csv -rw-r--r-- 1 landen supergroup 6802791 2013-03-27 18:48 /data/stocks/NASDAQ_daily_prices_K.csv -rw-r--r-- 1 landen supergroup 14740490 2013-03-27 18:48 /data/stocks/NASDAQ_daily_prices_L.csv -rw-r--r-- 1 landen supergroup 27819770 2013-03-27 18:48 /data/stocks/NASDAQ_daily_prices_M.csv -rw-r--r-- 1 landen supergroup 22606010 2013-03-27 18:48 /data/stocks/NASDAQ_daily_prices_N.csv -rw-r--r-- 1 landen supergroup 12256915 2013-03-27 18:48 /data/stocks/NASDAQ_daily_prices_O.csv -rw-r--r-- 1 landen supergroup 32128208 2013-03-27 18:48 /data/stocks/NASDAQ_daily_prices_P.csv -rw-r--r-- 1 landen supergroup 4533819 2013-03-27 18:48 /data/stocks/NASDAQ_daily_prices_Q.csv -rw-r--r-- 1 landen supergroup 17195728 2013-03-27 18:48 /data/stocks/NASDAQ_daily_prices_R.csv -rw-r--r-- 1 landen supergroup 40905480 2013-03-27 18:48 /data/stocks/NASDAQ_daily_prices_S.csv -rw-r--r-- 1 landen supergroup 23682619 2013-03-27 18:48 /data/stocks/NASDAQ_daily_prices_T.csv -rw-r--r-- 1 landen supergroup 10361495 2013-03-27 18:48 /data/stocks/NASDAQ_daily_prices_U.csv -rw-r--r-- 1 landen supergroup 9663807 2013-03-27 18:48 /data/stocks/NASDAQ_daily_prices_V.csv -rw-r--r-- 1 landen supergroup 13002916 2013-03-27 18:48 /data/stocks/NASDAQ_daily_prices_W.csv -rw-r--r-- 1 landen supergroup 2469618 2013-03-27 18:48 /data/stocks/NASDAQ_daily_prices_X.csv -rw-r--r-- 1 landen supergroup 1152634 2013-03-27 18:48 /data/stocks/NASDAQ_daily_prices_Y.csv -rw-r--r-- 1 landen supergroup 3321933 2013-03-27 18:48 /data/stocks/NASDAQ_daily_prices_Z.csv 现查看hdfs分布式文件系统下的某个文件，如下： landen@landen-Lenovo:~/UntarFile/hadoop-1.0.4$ bin/hadoop fs -cat /data/stocks/NASDAQ_daily_prices_Z.csv NASDAQ,ZION,1992-02-03,39.16,39.38,38.32,39.38,64800,3.38 NASDAQ,ZION,1992-01-31,37.89,38.53,37.89,38.53,110400,3.30 NASDAQ,ZION,1992-01-30,37.89,39.16,37.89,38.11,572800,3.27 NASDAQ,ZION,1992-01-29,36.20,38.32,36.20,37.89,154400,3.25 NASDAQ,ZION,1992-01-28,36.41,36.41,35.99,35.99,101600,3.09 NASDAQ,ZION,1992-01-27,37.05,37.05,37.05,37.05,3200,3.18 NASDAQ,ZION,1992-01-24,36.20,37.05,35.78,35.78,28000,3.07 NASDAQ,ZION,1992-01-23,37.89,37.89,36.41,36.41,72800,3.12 NASDAQ,ZION,1992-01-21,36.84,37.05,36.84,37.05,10400,3.18 NASDAQ,ZION,1992-01-20,36.84,37.89,36.84,37.89,2400,3.25 NASDAQ,ZION,1992-01-17,37.68,37.68,36.94,36.94,9600,3.17 NASDAQ,ZION,1992-01-16,35.78,37.26,35.57,37.26,150400,3.19 NASDAQ,ZION,1992-01-15,35.35,35.57,35.14,35.46,40000,3.04 NASDAQ,ZION,1992-01-14,34.72,34.72,34.51,34.72,108800,2.98 NASDAQ,ZION,1992-01-13,34.72,35.35,34.51,35.35,161600,3.03 NASDAQ,ZION,1992-01-10,33.66,35.14,33.66,34.30,130400,2.94 NASDAQ,ZION,1992-01-09,33.45,34.30,33.45,33.45,124800,2.87 NASDAQ,ZION,1992-01-08,34.30,34.30,33.45,34.30,64000,2.94 NASDAQ,ZION,1992-01-07,33.87,34.40,33.87,33.87,416000,2.90 NASDAQ,ZION,1992-01-06,35.78,36.20,34.30,34.72,144000,2.98 NASDAQ,ZION,1992-01-03,35.57,36.62,35.57,35.57,44800,3.05 NASDAQ,ZION,1992-01-02,36.31,36.62,35.57,35.57,20800,3.05 NASDAQ,ZION,1991-12-31,36.20,36.41,35.14,36.41,312800,3.12 NASDAQ,ZION,1991-12-30,34.63,35.26,34.63,35.26,6400,2.99 NASDAQ,ZION,1991-12-27,35.26,35.26,34.42,35.26,815200,2.99 NASDAQ,ZION,1991-12-26,34.00,35.05,34.00,34.63,310400,2.94 NASDAQ,ZION,1991-12-24,35.05,35.05,34.42,34.42,124000,2.92 NASDAQ,ZION,1991-12-23,34.21,34.42,33.58,34.42,462400,2.92 NASDAQ,ZION,1991-12-20,32.95,34.00,32.95,33.79,105600,2.87 NASDAQ,ZION,1991-12-19,32.74,33.48,32.74,33.48,121600,2.84 NASDAQ,ZION,1991-12-18,32.95,33.58,32.95,33.58,66400,2.85 NASDAQ,ZION,1991-12-17,33.37,33.37,33.16,33.37,32800,2.83 NASDAQ,ZION,1991-12-16,32.32,33.37,32.32,33.37,319200,2.83 NASDAQ,ZION,1991-12-13,32.74,32.74,32.11,32.11,8800,2.72 NASDAQ,ZION,1991-12-12,32.11,32.74,32.11,32.32,32800,2.74 NASDAQ,ZION,1991-12-11,32.95,33.16,32.11,32.11,92000,2.72 NASDAQ,ZION,1991-12-10,33.58,33.58,32.74,32.74,805600,2.78 NASDAQ,ZION,1991-12-09,33.16,34.00,33.16,33.58,135200,2.85 NASDAQ,ZION,1991-12-06,33.58,34.00,33.16,33.16,82400,2.81 NASDAQ,ZION,1991-12-05,34.63,34.63,33.79,33.79,9600,2.87 NASDAQ,ZION,1991-12-04,33.79,34.63,33.79,34.63,3200,2.94 NASDAQ,ZION,1991-12-03,33.58,34.42,33.58,33.79,307200,2.87 NASDAQ,ZION,1991-12-02,35.68,35.68,34.00,34.00,41600,2.89 NASDAQ,ZION,1991-11-29,35.68,35.79,35.26,35.26,49600,2.99 NASDAQ,ZION,1991-11-27,36.94,36.94,36.52,36.52,29600,3.10 NASDAQ,ZION,1991-11-25,36.94,36.94,36.94,36.94,800,3.13 NASDAQ,ZION,1991-11-22,36.94,36.94,36.94,36.94,1600,3.13 NASDAQ,ZION,1991-11-21,37.15,37.15,36.94,36.94,11200,3.13 NASDAQ,ZION,1991-11-20,37.57,37.78,37.36,37.36,31200,3.17 NASDAQ,ZION,1991-11-19,37.57,37.57,37.57,37.57,15200,3.19 NASDAQ,ZION,1991-11-18,37.99,38.41,37.78,37.78,59200,3.21 NASDAQ,ZION,1991-11-15,38.83,38.93,38.20,38.20,64800,3.24 NASDAQ,ZION,1991-11-14,39.04,39.46,38.93,39.46,60800,3.35 NASDAQ,ZION,1991-11-13,39.25,39.25,38.93,38.93,261600,3.30 NASDAQ,ZION,1991-11-12,39.46,39.46,39.25,39.25,16000,3.33 NASDAQ,ZION,1991-11-11,39.25,39.25,39.25,39.25,11200,3.33 NASDAQ,ZION,1991-11-08,39.04,39.67,39.04,39.46,166400,3.35 NASDAQ,ZION,1991-11-07,39.04,39.04,39.04,39.04,3200,3.31 NASDAQ,ZION,1991-11-06,39.04,39.25,39.04,39.25,16000,3.33 NASDAQ,ZION,1991-11-04,39.04,39.46,39.04,39.35,230400,3.34 NASDAQ,ZION,1991-11-01,39.04,39.67,39.04,39.67,2400,3.37 NASDAQ,ZION,1991-10-31,39.46,39.46,39.25,39.25,17600,3.33 NASDAQ,ZION,1991-10-30,39.25,39.46,39.25,39.46,24000,3.35 NASDAQ,ZION,1991-10-28,37.99,37.99,37.36,37.36,2400,3.17 NASDAQ,ZION,1991-10-25,37.36,37.99,37.36,37.99,14400,3.22 NASDAQ,ZION,1991-10-24,37.36,38.62,37.36,38.09,252800,3.23 NASDAQ,ZION,1991-10-23,38.51,38.51,37.36,37.46,442400,3.18 NASDAQ,ZION,1991-10-21,37.78,38.09,37.78,38.09,14400,3.23 NASDAQ,ZION,1991-10-18,38.62,38.83,37.78,37.78,112000,3.21 NASDAQ,ZION,1991-10-17,39.67,39.67,39.04,39.04,129600,3.31 NASDAQ,ZION,1991-10-16,37.78,39.88,37.78,39.88,652800,3.38 NASDAQ,ZION,1991-10-15,37.36,38.41,37.36,38.41,48000,3.26 NASDAQ,ZION,1991-10-14,37.36,37.36,37.36,37.36,800,3.17 NASDAQ,ZION,1991-10-11,37.36,37.36,37.36,37.36,3200,3.17 NASDAQ,ZION,1991-10-08,37.99,37.99,36.94,37.88,79200,3.21 NASDAQ,ZION,1991-10-07,36.94,37.99,36.83,37.99,1596000,3.22 NASDAQ,ZION,1991-10-04,37.36,37.78,36.94,37.25,138400,3.16 NASDAQ,ZION,1991-10-03,37.78,37.78,36.94,37.36,14400,3.17 NASDAQ,ZION,1991-10-02,37.57,37.99,37.36,37.78,189600,3.21 NASDAQ,ZION,1991-10-01,37.57,37.57,37.57,37.57,12000,3.19 NASDAQ,ZION,1991-09-30,37.78,38.62,37.57,37.57,23200,3.19 NASDAQ,ZION,1991-09-27,39.46,39.46,38.20,38.20,39200,3.24 NASDAQ,ZION,1991-09-26,38.62,38.62,38.62,38.62,2400,3.28 NASDAQ,ZION,1991-09-25,39.14,39.46,38.83,39.46,85600,3.35 NASDAQ,ZION,1991-09-24,39.46,39.88,39.04,39.04,58400,3.31 NASDAQ,ZION,1991-09-20,39.04,39.04,39.04,39.04,24000,3.31 NASDAQ,ZION,1991-09-19,39.88,39.88,39.04,39.04,375200,3.31 NASDAQ,ZION,1991-09-18,39.46,39.88,39.25,39.46,33600,3.35 NASDAQ,ZION,1991-09-17,39.46,39.46,39.46,39.46,4000,3.35 NASDAQ,ZION,1991-09-16,39.88,40.30,39.46,39.46,45600,3.35 NASDAQ,ZION,1991-09-13,39.88,40.30,39.88,39.98,32800,3.39 NASDAQ,ZION,1991-09-12,39.88,39.88,39.88,39.88,800,3.38 NASDAQ,ZION,1991-09-11,39.35,39.35,38.83,38.83,8800,3.29 NASDAQ,ZION,1991-09-10,39.46,39.46,39.46,39.46,8800,3.35 NASDAQ,ZION,1991-09-09,40.72,40.72,39.46,39.46,32800,3.35 NASDAQ,ZION,1991-09-06,40.51,40.72,39.67,39.67,69600,3.37 NASDAQ,ZION,1991-09-05,41.14,41.14,40.51,40.93,13600,3.47 NASDAQ,ZION,1991-09-04,40.72,40.72,40.72,40.72,22400,3.45 NASDAQ,ZION,1991-09-03,41.24,41.77,40.93,41.77,12000,3.54 NASDAQ,ZION,1991-08-30,40.93,41.14,40.93,41.03,34400,3.48 NASDAQ,ZION,1991-08-29,40.93,40.93,40.93,40.93,8800,3.47 NASDAQ,ZION,1991-08-28,41.14,41.14,40.93,40.93,38400,3.47 NASDAQ,ZION,1991-08-27,41.14,41.98,41.14,41.14,91200,3.49 NASDAQ,ZION,1991-08-26,41.98,41.98,41.14,41.14,92800,3.49 NASDAQ,ZION,1991-08-23,41.98,41.98,41.14,41.14,164000,3.49 NASDAQ,ZION,1991-08-22,40.72,41.77,40.72,41.77,104800,3.54 NASDAQ,ZION,1991-08-21,40.72,41.56,40.72,41.14,89600,3.49 NASDAQ,ZION,1991-08-20,40.51,40.93,39.67,40.30,161600,3.42 NASDAQ,ZION,1991-08-19,40.09,40.09,39.46,39.46,24800,3.35 NASDAQ,ZION,1991-08-16,41.14,41.14,39.88,39.88,79200,3.38 NASDAQ,ZION,1991-08-15,40.51,40.51,39.88,39.88,8000,3.38 NASDAQ,ZION,1991-08-14,40.09,41.14,39.88,39.88,67200,3.38 NASDAQ,ZION,1991-08-13,38.62,40.30,38.62,40.30,138400,3.42 NASDAQ,ZION,1991-08-12,39.67,39.67,38.62,38.62,4000,3.28 NASDAQ,ZION,1991-08-09,38.62,39.46,38.62,39.46,80000,3.35 NASDAQ,ZION,1991-08-08,38.83,38.83,38.62,38.62,58400,3.28 NASDAQ,ZION,1991-08-07,38.83,39.14,38.83,39.14,20800,3.32 NASDAQ,ZION,1991-08-06,38.83,38.83,38.83,38.83,16800,3.29 NASDAQ,ZION,1991-08-05,38.83,39.67,38.83,39.14,23200,3.32 NASDAQ,ZION,1991-08-02,38.83,39.67,38.62,38.83,70400,3.29 NASDAQ,ZION,1991-08-01,37.78,38.83,37.78,38.09,41600,3.23 NASDAQ,ZION,1991-07-31,36.94,38.20,36.94,37.78,93600,3.21 NASDAQ,ZION,1991-07-30,36.10,37.36,36.10,37.36,170400,3.17 NASDAQ,ZION,1991-07-29,36.10,36.94,36.10,36.94,6400,3.13 NASDAQ,ZION,1991-07-26,36.10,36.63,36.10,36.63,236000,3.11 NASDAQ,ZION,1991-07-25,36.10,36.10,36.10,36.10,4800,3.06 NASDAQ,ZION,1991-07-24,36.10,36.94,36.10,36.94,14400,3.13 NASDAQ,ZION,1991-07-23,36.10,36.94,36.10,36.10,779200,3.06 NASDAQ,ZION,1991-07-22,36.94,36.94,36.31,36.73,161600,3.12 NASDAQ,ZION,1991-07-19,35.89,36.73,35.89,36.52,376000,3.10 NASDAQ,ZION,1991-07-18,34.74,35.79,34.63,35.68,784000,3.03 NASDAQ,ZION,1991-07-17,34.21,34.84,34.21,34.42,17600,2.92 NASDAQ,ZION,1991-07-16,35.26,35.26,34.42,34.84,144800,2.96 NASDAQ,ZION,1991-07-15,34.32,35.26,34.32,34.42,505600,2.92 NASDAQ,ZION,1991-07-12,34.42,34.63,34.00,34.00,41600,2.89 NASDAQ,ZION,1991-07-11,34.21,34.32,34.00,34.00,82400,2.89 NASDAQ,ZION,1991-07-10,34.00,34.84,33.79,34.21,276800,2.90 NASDAQ,ZION,1991-07-09,33.79,34.00,33.58,34.00,246400,2.89 NASDAQ,ZION,1991-07-08,32.95,33.79,32.95,33.58,253600,2.85 NASDAQ,ZION,1991-07-05,33.58,34.00,33.58,34.00,4800,2.89 NASDAQ,ZION,1991-07-03,33.16,34.21,33.16,33.79,237600,2.87 NASDAQ,ZION,1991-07-02,33.58,34.21,33.58,33.69,24000,2.86 NASDAQ,ZION,1991-07-01,33.58,34.21,33.37,33.69,205600,2.86 NASDAQ,ZION,1991-06-28,33.69,33.79,33.37,33.58,117600,2.85 NASDAQ,ZION,1991-06-27,33.79,34.21,33.16,33.69,225600,2.86 NASDAQ,ZION,1991-06-26,33.79,34.00,33.37,34.00,68000,2.89 NASDAQ,ZION,1991-06-25,33.58,34.00,33.48,33.58,300800,2.85 NASDAQ,ZION,1991-06-24,33.79,34.63,33.58,33.69,80000,2.86 NASDAQ,ZION,1991-06-21,33.79,34.42,33.58,33.79,24000,2.87 NASDAQ,ZION,1991-06-20,34.00,34.63,33.79,34.21,156800,2.90 NASDAQ,ZION,1991-06-19,34.63,34.63,33.79,34.21,18400,2.90 NASDAQ,ZION,1991-06-18,34.84,34.84,34.00,34.42,88800,2.92 NASDAQ,ZION,1991-06-17,34.00,34.84,34.00,34.00,80800,2.89 NASDAQ,ZION,1991-06-14,34.00,34.63,34.00,34.63,22400,2.94 NASDAQ,ZION,1991-06-13,34.00,34.63,33.79,33.79,833600,2.87 NASDAQ,ZION,1991-06-12,34.21,35.26,34.00,34.84,32800,2.96 NASDAQ,ZION,1991-06-11,34.84,35.47,34.74,34.84,204800,2.96 NASDAQ,ZION,1991-06-10,35.47,35.47,34.63,35.26,83200,2.99 NASDAQ,ZION,1991-06-07,34.84,35.47,34.42,34.95,306400,2.97 NASDAQ,ZION,1991-06-06,34.42,35.26,34.21,35.26,188000,2.99 NASDAQ,ZION,1991-06-05,34.42,34.84,34.42,34.42,97600,2.92 NASDAQ,ZION,1991-06-04,34.95,35.26,34.21,34.21,82400,2.90 NASDAQ,ZION,1991-06-03,35.47,35.47,34.42,34.42,13600,2.92 NASDAQ,ZION,1991-05-31,34.42,35.68,34.42,35.68,10400,3.03 NASDAQ,ZION,1991-05-30,35.68,35.68,34.42,34.63,144000,2.94 NASDAQ,ZION,1991-05-29,34.63,35.68,34.63,35.16,12000,2.98 NASDAQ,ZION,1991-05-28,35.68,35.68,34.63,34.63,68800,2.94 NASDAQ,ZION,1991-05-24,35.05,35.68,35.05,35.68,2400,3.03 NASDAQ,ZION,1991-05-23,35.05,35.05,35.05,35.05,800,2.97 NASDAQ,ZION,1991-05-21,35.05,35.89,35.05,35.89,11200,3.05 NASDAQ,ZION,1991-05-20,35.26,35.26,35.26,35.26,4000,2.99 NASDAQ,ZION,1991-05-17,35.89,35.89,35.89,35.89,800,3.05 NASDAQ,ZION,1991-05-16,35.26,35.68,35.26,35.26,8000,2.99 NASDAQ,ZION,1991-05-15,35.26,36.10,35.26,35.26,6400,2.99 NASDAQ,ZION,1991-05-14,35.89,36.52,35.68,35.79,64000,3.04 NASDAQ,ZION,1991-05-13,35.68,36.63,35.68,36.31,286400,3.08 NASDAQ,ZION,1991-05-10,36.10,36.10,35.89,35.89,36800,3.05 NASDAQ,ZION,1991-05-09,35.26,35.47,35.26,35.47,4800,3.01 NASDAQ,ZION,1991-05-08,35.05,35.26,35.05,35.26,4000,2.99 NASDAQ,ZION,1991-05-07,35.05,35.58,35.05,35.47,46400,3.01 NASDAQ,ZION,1991-05-06,35.26,35.26,35.05,35.05,1600,2.97 NASDAQ,ZION,1991-05-03,35.05,35.47,35.05,35.47,84000,3.01 NASDAQ,ZION,1991-05-01,35.26,35.26,34.84,35.26,180000,2.99 NASDAQ,ZION,1991-04-30,34.63,35.26,34.21,34.42,49600,2.92 NASDAQ,ZION,1991-04-29,35.68,35.68,34.42,34.42,105600,2.92 NASDAQ,ZION,1991-04-26,35.68,35.68,35.68,35.68,4000,3.03 NASDAQ,ZION,1991-04-25,35.26,35.79,35.26,35.47,124800,3.01 NASDAQ,ZION,1991-04-24,34.21,35.47,34.21,35.26,208800,2.99 NASDAQ,ZION,1991-04-23,34.21,34.63,34.21,34.21,69600,2.90 NASDAQ,ZION,1991-04-22,34.00,34.63,34.00,34.63,67200,2.94 NASDAQ,ZION,1991-04-19,34.84,34.84,34.42,34.42,96000,2.92 NASDAQ,ZION,1991-04-18,35.89,36.73,35.05,35.05,127200,2.97 NASDAQ,ZION,1991-04-17,34.21,36.73,34.21,36.73,180000,3.12 NASDAQ,ZION,1991-04-16,33.79,34.63,33.16,34.63,149600,2.94 NASDAQ,ZION,1991-04-15,32.74,33.79,32.74,32.74,118400,2.78 NASDAQ,ZION,1991-04-12,32.74,33.37,32.74,32.95,120800,2.80 NASDAQ,ZION,1991-04-11,33.79,33.79,32.74,32.74,6400,2.78 NASDAQ,ZION,1991-04-10,32.74,33.16,32.74,32.74,37600,2.78 NASDAQ,ZION,1991-04-09,32.95,32.95,32.74,32.74,143200,2.78 NASDAQ,ZION,1991-04-08,31.90,32.74,31.90,32.53,132800,2.76 NASDAQ,ZION,1991-04-05,31.69,32.43,31.69,31.90,137600,2.71 NASDAQ,ZION,1991-04-04,31.06,32.11,31.06,31.80,187200,2.70 NASDAQ,ZION,1991-04-03,30.64,31.38,30.64,31.06,420000,2.64 NASDAQ,ZION,1991-04-02,30.01,30.43,30.01,30.43,215200,2.58 NASDAQ,ZION,1991-04-01,30.13,30.24,30.13,30.24,20800,2.54 NASDAQ,ZION,1991-03-28,30.65,31.17,30.13,30.13,122400,2.53 NASDAQ,ZION,1991-03-27,30.34,31.17,30.34,30.76,54400,2.58 NASDAQ,ZION,1991-03-26,29.92,30.55,29.92,30.55,85600,2.56 NASDAQ,ZION,1991-03-25,29.92,30.34,29.92,30.34,18400,2.54 NASDAQ,ZION,1991-03-22,29.92,30.13,29.92,30.13,30400,2.53 NASDAQ,ZION,1991-03-21,29.92,30.55,29.92,29.92,50400,2.51 NASDAQ,ZION,1991-03-20,29.92,30.55,29.92,30.55,9600,2.56 NASDAQ,ZION,1991-03-19,30.55,30.55,30.24,30.24,75200,2.54 NASDAQ,ZION,1991-03-18,29.72,30.55,29.72,30.55,94400,2.56 NASDAQ,ZION,1991-03-15,29.92,30.13,29.92,29.92,22400,2.51 NASDAQ,ZION,1991-03-14,30.76,30.76,30.76,30.76,800,2.58 NASDAQ,ZION,1991-03-13,29.92,30.13,29.92,30.13,21600,2.53 NASDAQ,ZION,1991-03-12,29.92,29.92,29.92,29.92,22400,2.51 NASDAQ,ZION,1991-03-11,30.76,30.76,30.55,30.55,8800,2.56 NASDAQ,ZION,1991-03-08,29.92,30.76,29.92,30.76,230400,2.58 NASDAQ,ZION,1991-03-07,30.76,30.76,30.13,30.24,60000,2.54 NASDAQ,ZION,1991-03-06,29.61,30.76,29.61,30.13,106400,2.53 NASDAQ,ZION,1991-03-05,29.30,29.92,29.30,29.92,5600,2.51 NASDAQ,ZION,1991-03-04,29.09,29.92,29.09,29.30,36800,2.46 NASDAQ,ZION,1991-03-01,29.09,29.92,29.09,29.09,41600,2.44 NASDAQ,ZION,1991-02-28,29.92,30.13,29.09,29.51,28000,2.47 NASDAQ,ZION,1991-02-27,29.09,29.09,29.09,29.09,3200,2.44 NASDAQ,ZION,1991-02-26,29.09,29.72,29.09,29.20,28800,2.45 NASDAQ,ZION,1991-02-25,29.09,29.09,29.09,29.09,2400,2.44 NASDAQ,ZION,1991-02-22,29.09,29.30,29.09,29.09,23200,2.44 NASDAQ,ZION,1991-02-21,29.51,30.34,29.09,29.30,8800,2.46 NASDAQ,ZION,1991-02-20,29.92,30.24,29.72,29.92,110400,2.51 NASDAQ,ZION,1991-02-19,30.34,30.34,30.13,30.13,48800,2.53 NASDAQ,ZION,1991-02-15,30.96,30.96,30.34,30.34,24000,2.54 NASDAQ,ZION,1991-02-14,29.92,31.59,29.92,30.55,79200,2.56 NASDAQ,ZION,1991-02-13,29.92,30.55,29.51,30.13,281600,2.53 NASDAQ,ZION,1991-02-12,28.47,29.72,28.47,29.72,112000,2.49 NASDAQ,ZION,1991-02-11,28.26,28.47,28.26,28.26,112000,2.37 NASDAQ,ZION,1991-02-08,28.05,28.47,28.05,28.26,57600,2.37 NASDAQ,ZION,1991-02-07,28.05,28.68,28.05,28.05,91200,2.35 NASDAQ,ZION,1991-02-06,28.05,28.05,28.05,28.05,12000,2.35 NASDAQ,ZION,1991-02-05,28.05,28.68,28.05,28.68,54400,2.40 NASDAQ,ZION,1991-02-04,28.05,28.47,27.43,27.43,96000,2.30 NASDAQ,ZION,1991-02-01,27.43,28.26,27.22,27.53,245600,2.31 NASDAQ,ZION,1991-01-31,27.22,27.95,27.22,27.43,136000,2.30 NASDAQ,ZION,1991-01-30,28.05,28.05,27.22,27.22,55200,2.28 NASDAQ,ZION,1991-01-29,27.22,28.05,27.22,27.22,29600,2.28 NASDAQ,ZION,1991-01-28,27.22,27.33,27.22,27.22,69600,2.28 NASDAQ,ZION,1991-01-25,26.18,27.85,26.18,27.22,356800,2.28 NASDAQ,ZION,1991-01-24,25.35,26.60,24.73,26.60,132000,2.23 NASDAQ,ZION,1991-01-23,24.94,25.56,24.73,25.56,34400,2.14 NASDAQ,ZION,1991-01-21,24.73,25.14,24.73,24.94,18400,2.09 NASDAQ,ZION,1991-01-18,25.77,25.77,24.73,25.77,18400,2.16 NASDAQ,ZION,1991-01-17,24.73,25.14,24.52,24.73,78400,2.07 NASDAQ,ZION,1991-01-16,24.11,24.73,24.11,24.31,25600,2.04 NASDAQ,ZION,1991-01-15,23.90,23.90,23.90,23.90,4000,2.00 NASDAQ,ZION,1991-01-14,24.73,24.73,23.90,23.90,36000,2.00 NASDAQ,ZION,1991-01-11,24.31,24.94,24.31,24.94,22400,2.09 NASDAQ,ZION,1991-01-10,24.52,24.73,24.31,24.31,76800,2.04 NASDAQ,ZION,1991-01-09,25.35,25.35,24.73,24.94,22400,2.09 NASDAQ,ZION,1991-01-08,24.52,24.73,24.52,24.73,39200,2.07 NASDAQ,ZION,1991-01-07,25.35,25.35,24.52,24.52,127200,2.06 NASDAQ,ZION,1991-01-04,25.35,26.18,25.35,25.35,12000,2.13 NASDAQ,ZION,1991-01-03,25.56,25.98,25.35,25.35,108800,2.13 NASDAQ,ZION,1991-01-02,25.35,25.77,25.14,25.14,6400,2.11 NASDAQ,ZION,1990-12-31,25.77,26.39,25.35,26.39,50400,2.21 NASDAQ,ZION,1990-12-28,25.77,25.77,25.77,25.77,14400,2.16 NASDAQ,ZION,1990-12-27,25.35,26.39,25.35,26.18,68800,2.20 NASDAQ,ZION,1990-12-26,25.35,26.18,25.14,25.35,44000,2.13 NASDAQ,ZION,1990-12-24,24.64,24.64,24.64,24.64,4000,2.04 NASDAQ,ZION,1990-12-21,24.64,25.05,24.64,25.05,165600,2.07 NASDAQ,ZION,1990-12-20,24.02,24.95,24.02,24.64,52000,2.04 NASDAQ,ZION,1990-12-19,24.02,24.64,24.02,24.64,9600,2.04 NASDAQ,ZION,1990-12-18,24.02,24.64,24.02,24.02,43200,1.98 NASDAQ,ZION,1990-12-14,24.84,24.84,24.02,24.02,24800,1.98 NASDAQ,ZION,1990-12-12,24.64,24.84,24.02,24.64,68800,2.04 NASDAQ,ZION,1990-12-11,24.02,24.64,24.02,24.64,12800,2.04 NASDAQ,ZION,1990-12-10,24.02,24.64,24.02,24.64,31200,2.04 NASDAQ,ZION,1990-12-07,24.02,24.43,24.02,24.43,55200,2.02 NASDAQ,ZION,1990-12-06,24.02,24.43,23.82,23.82,67200,1.97 NASDAQ,ZION,1990-12-05,23.82,24.43,23.82,24.43,22400,2.02 NASDAQ,ZION,1990-12-04,23.61,24.02,23.61,24.02,23200,1.98 NASDAQ,ZION,1990-12-03,23.61,23.82,23.61,23.61,6400,1.95 NASDAQ,ZION,1990-11-30,23.92,24.02,23.61,24.02,45600,1.98 NASDAQ,ZION,1990-11-29,23.61,23.71,23.61,23.71,25600,1.96 NASDAQ,ZION,1990-11-28,23.61,23.82,23.61,23.82,24000,1.97 NASDAQ,ZION,1990-11-27,23.61,23.71,23.61,23.61,28000,1.95 NASDAQ,ZION,1990-11-26,23.61,23.82,23.61,23.82,114400,1.97 NASDAQ,ZION,1990-11-23,23.61,23.61,23.61,23.61,16000,1.95 NASDAQ,ZION,1990-11-21,23.61,23.61,23.61,23.61,20000,1.95 NASDAQ,ZION,1990-11-20,23.41,24.02,23.41,23.61,51200,1.95 NASDAQ,ZION,1990-11-19,23.82,24.02,23.82,24.02,2400,1.98 NASDAQ,ZION,1990-11-16,23.41,23.82,23.41,23.41,15200,1.93 NASDAQ,ZION,1990-11-15,23.71,23.71,23.41,23.41,40000,1.93 NASDAQ,ZION,1990-11-14,23.61,24.02,23.61,24.02,3200,1.98 NASDAQ,ZION,1990-11-13,23.41,24.43,23.41,24.23,128800,2.00 NASDAQ,ZION,1990-11-12,22.38,23.20,22.38,22.58,54400,1.87 NASDAQ,ZION,1990-11-09,21.97,22.79,21.97,22.79,19200,1.88 NASDAQ,ZION,1990-11-08,21.97,22.28,21.97,22.28,11200,1.84 NASDAQ,ZION,1990-11-07,22.38,22.58,21.97,21.97,56000,1.81 NASDAQ,ZION,1990-11-06,21.76,21.97,21.76,21.97,24000,1.81 NASDAQ,ZION,1990-11-02,21.56,22.17,21.56,22.17,27200,1.83 NASDAQ,ZION,1990-11-01,21.35,22.17,21.35,21.56,212000,1.78 NASDAQ,ZION,1990-10-31,21.76,21.76,21.35,21.35,17600,1.76 NASDAQ,ZION,1990-10-30,21.76,21.76,21.15,21.15,25600,1.75 NASDAQ,ZION,1990-10-29,21.35,21.76,21.15,21.46,107200,1.77 NASDAQ,ZION,1990-10-26,21.15,21.97,21.15,21.35,145600,1.76 NASDAQ,ZION,1990-10-25,20.94,21.35,20.94,21.15,72000,1.75 NASDAQ,ZION,1990-10-24,21.15,21.15,20.94,21.15,101600,1.75 NASDAQ,ZION,1990-10-23,21.15,21.15,20.74,20.94,288000,1.73 NASDAQ,ZION,1990-10-22,20.74,20.74,20.74,20.74,32800,1.71 NASDAQ,ZION,1990-10-19,21.15,21.15,20.74,20.74,36000,1.71 NASDAQ,ZION,1990-10-18,20.94,21.04,20.53,20.94,48000,1.73 NASDAQ,ZION,1990-10-16,20.94,20.94,20.53,20.53,40000,1.70 NASDAQ,ZION,1990-10-15,20.94,20.94,20.33,20.33,81600,1.68 NASDAQ,ZION,1990-10-12,20.53,20.53,20.12,20.12,7200,1.66 NASDAQ,ZION,1990-10-11,20.53,20.63,20.53,20.53,87200,1.70 NASDAQ,ZION,1990-10-10,20.74,21.15,20.53,21.15,128000,1.75 NASDAQ,ZION,1990-10-09,20.53,21.15,20.53,20.53,66400,1.70 NASDAQ,ZION,1990-10-08,20.53,20.53,20.53,20.53,6400,1.70 NASDAQ,ZION,1990-10-05,20.53,20.53,20.53,20.53,4800,1.70 NASDAQ,ZION,1990-10-04,20.53,20.53,20.53,20.53,8800,1.70 NASDAQ,ZION,1990-10-03,20.53,20.53,20.53,20.53,800,1.70 NASDAQ,ZION,1990-10-02,20.74,21.15,20.74,20.74,15200,1.71 NASDAQ,ZION,1990-10-01,20.33,20.74,20.33,20.33,130400,1.68 NASDAQ,ZION,1990-09-28,20.33,20.94,20.12,20.43,48000,1.69 NASDAQ,ZION,1990-09-27,20.94,20.94,20.33,20.33,166400,1.68 NASDAQ,ZION,1990-09-26,21.15,21.15,20.74,20.94,54400,1.73 NASDAQ,ZION,1990-09-25,20.53,20.84,20.33,20.33,34400,1.68 NASDAQ,ZION,1990-09-24,20.24,20.64,20.24,20.24,655200,1.64 NASDAQ,ZION,1990-09-20,20.64,20.64,20.44,20.44,5600,1.66 NASDAQ,ZION,1990-09-18,20.24,21.05,20.24,20.24,29600,1.64 NASDAQ,ZION,1990-09-17,21.05,21.05,20.24,20.24,12000,1.64 NASDAQ,ZION,1990-09-14,20.24,20.24,20.24,20.24,9600,1.64 NASDAQ,ZION,1990-09-12,20.24,20.24,20.24,20.24,4000,1.64 NASDAQ,ZION,1990-09-11,20.24,20.24,20.24,20.24,800,1.64 NASDAQ,ZION,1990-09-10,21.05,21.05,20.34,20.34,10400,1.65 NASDAQ,ZION,1990-09-07,20.44,20.44,20.44,20.44,12000,1.66 NASDAQ,ZION,1990-09-06,21.05,21.05,20.24,20.24,19200,1.64 NASDAQ,ZION,1990-09-05,20.64,21.05,20.24,20.24,28800,1.64 NASDAQ,ZION,1990-09-04,20.24,20.24,20.24,20.24,1600,1.64 NASDAQ,ZION,1990-08-31,20.44,20.44,20.24,20.24,7200,1.64 NASDAQ,ZION,1990-08-30,20.44,20.44,20.44,20.44,4800,1.66 NASDAQ,ZION,1990-08-29,20.64,20.64,20.44,20.44,10400,1.66 NASDAQ,ZION,1990-08-28,21.05,21.05,20.24,20.24,80800,1.64 NASDAQ,ZION,1990-08-27,21.05,21.05,20.44,20.44,5600,1.66 NASDAQ,ZION,1990-08-24,19.83,21.05,19.83,21.05,48000,1.71 NASDAQ,ZION,1990-08-23,21.45,21.45,20.24,20.24,96000,1.64 NASDAQ,ZION,1990-08-22,21.45,21.45,21.45,21.45,12000,1.74 NASDAQ,ZION,1990-08-21,21.96,22.46,21.85,21.85,61600,1.77 NASDAQ,ZION,1990-08-20,22.06,22.06,22.06,22.06,2400,1.79 NASDAQ,ZION,1990-08-17,22.06,22.16,21.85,21.85,33600,1.77 NASDAQ,ZION,1990-08-16,22.06,22.06,22.06,22.06,4000,1.79 NASDAQ,ZION,1990-08-15,22.06,22.26,22.06,22.26,42400,1.81 NASDAQ,ZION,1990-08-14,22.66,22.66,22.06,22.06,6400,1.79 NASDAQ,ZION,1990-08-13,22.26,22.46,22.26,22.36,168800,1.81 NASDAQ,ZION,1990-08-10,22.46,22.66,22.26,22.66,37600,1.84 NASDAQ,ZION,1990-08-07,22.66,23.47,22.66,22.66,5600,1.84 NASDAQ,ZION,1990-08-06,23.88,23.88,22.77,23.07,412000,1.87 NASDAQ,ZION,1990-08-03,24.08,24.08,23.47,24.08,353600,1.95 NASDAQ,ZION,1990-08-02,23.88,24.49,23.88,24.49,302400,1.99 NASDAQ,ZION,1990-08-01,24.69,24.69,23.88,24.18,52000,1.96 NASDAQ,ZION,1990-07-31,23.68,24.49,23.68,24.18,365600,1.96 NASDAQ,ZION,1990-07-30,23.27,23.68,23.07,23.68,25600,1.92 NASDAQ,ZION,1990-07-27,23.47,23.47,23.47,23.47,800,1.90 NASDAQ,ZION,1990-07-26,22.87,22.97,22.87,22.97,40800,1.86 NASDAQ,ZION,1990-07-25,22.87,23.07,22.87,22.87,41600,1.86 NASDAQ,ZION,1990-07-24,23.27,23.27,22.87,22.87,36000,1.86 NASDAQ,ZION,1990-07-23,22.87,23.07,22.87,23.07,83200,1.87 NASDAQ,ZION,1990-07-20,23.27,23.27,22.66,22.66,5600,1.84 NASDAQ,ZION,1990-07-18,22.66,22.66,22.66,22.66,800,1.84 NASDAQ,ZION,1990-07-17,22.66,22.87,22.66,22.87,17600,1.86 NASDAQ,ZION,1990-07-16,22.66,23.27,22.66,22.66,31200,1.84 NASDAQ,ZION,1990-07-13,23.27,23.27,22.66,22.66,23200,1.84 NASDAQ,ZION,1990-07-12,22.46,23.27,22.46,23.27,128800,1.89 NASDAQ,ZION,1990-07-11,23.07,23.07,22.46,22.46,96000,1.82 NASDAQ,ZION,1990-07-10,22.26,23.07,22.26,23.07,19200,1.87 NASDAQ,ZION,1990-07-09,23.27,23.27,22.26,22.26,60000,1.81 NASDAQ,ZION,1990-07-06,23.27,23.47,23.27,23.47,7200,1.90 NASDAQ,ZION,1990-07-05,22.66,23.27,22.66,22.66,3200,1.84 NASDAQ,ZION,1990-07-03,23.47,23.47,23.47,23.47,8800,1.90 NASDAQ,ZION,1990-07-02,23.07,23.47,22.87,22.87,28800,1.86 NASDAQ,ZION,1990-06-29,22.87,23.47,22.87,23.17,16000,1.88 NASDAQ,ZION,1990-06-28,22.87,22.87,22.87,22.87,1600,1.86 NASDAQ,ZION,1990-06-27,23.47,23.47,22.87,22.87,13600,1.86 NASDAQ,ZION,1990-06-26,22.87,22.97,22.87,22.97,113600,1.86 NASDAQ,ZION,1990-06-25,22.87,23.17,22.87,22.87,80000,1.86 NASDAQ,ZION,1990-06-22,23.37,23.37,22.87,22.87,37600,1.86 NASDAQ,ZION,1990-06-21,22.87,23.47,22.87,23.37,8000,1.90 NASDAQ,ZION,1990-06-20,23.27,23.47,23.07,23.07,97600,1.87 NASDAQ,ZION,1990-06-19,23.47,23.47,23.27,23.37,79200,1.90 NASDAQ,ZION,1990-06-18,23.47,24.08,23.47,23.78,72800,1.93 NASDAQ,ZION,1990-06-15,23.47,24.08,23.47,23.47,16000,1.90 NASDAQ,ZION,1990-06-14,23.57,23.57,23.57,23.57,5600,1.91 NASDAQ,ZION,1990-06-13,23.47,23.68,23.47,23.47,85600,1.90 NASDAQ,ZION,1990-06-12,23.27,23.27,23.27,23.27,8000,1.89 NASDAQ,ZION,1990-06-11,23.27,23.47,23.27,23.47,11200,1.90 NASDAQ,ZION,1990-06-08,23.27,23.37,23.27,23.27,9600,1.89 NASDAQ,ZION,1990-06-07,23.47,24.08,23.47,24.08,3200,1.95 NASDAQ,ZION,1990-06-06,23.27,23.68,23.27,23.68,67200,1.92 NASDAQ,ZION,1990-06-05,23.07,23.37,23.07,23.27,25600,1.89 NASDAQ,ZION,1990-06-04,23.07,23.07,23.07,23.07,11200,1.87 NASDAQ,ZION,1990-06-01,23.07,23.07,23.07,23.07,16000,1.87 NASDAQ,ZION,1990-05-31,23.57,23.88,23.37,23.88,21600,1.94 NASDAQ,ZION,1990-05-30,23.07,23.47,23.07,23.17,56000,1.88 NASDAQ,ZION,1990-05-29,23.07,23.07,23.07,23.07,4000,1.87 NASDAQ,ZION,1990-05-25,23.07,23.07,23.07,23.07,800,1.87 NASDAQ,ZION,1990-05-24,23.07,23.07,23.07,23.07,8800,1.87 NASDAQ,ZION,1990-05-23,23.07,23.07,23.07,23.07,1600,1.87 NASDAQ,ZION,1990-05-22,23.47,23.47,23.07,23.07,12000,1.87 NASDAQ,ZION,1990-05-21,22.87,23.07,22.87,22.87,12800,1.86 NASDAQ,ZION,1990-05-18,22.87,23.37,22.87,22.87,20000,1.86 NASDAQ,ZION,1990-05-17,22.87,23.17,22.87,23.07,115200,1.87 NASDAQ,ZION,1990-05-16,22.87,23.07,22.87,23.07,45600,1.87 NASDAQ,ZION,1990-05-15,22.66,23.68,22.66,22.87,21600,1.86 NASDAQ,ZION,1990-05-14,22.97,23.68,22.66,23.68,30400,1.92 NASDAQ,ZION,1990-05-11,22.97,23.07,22.66,22.97,38400,1.86 NASDAQ,ZION,1990-05-10,22.66,22.97,22.66,22.97,139200,1.86 NASDAQ,ZION,1990-05-09,23.47,23.68,22.66,23.27,29600,1.89 NASDAQ,ZION,1990-05-08,23.47,23.47,23.47,23.47,56800,1.90 NASDAQ,ZION,1990-05-07,23.47,23.57,23.47,23.57,7200,1.91 NASDAQ,ZION,1990-05-04,24.28,24.28,23.47,23.57,72800,1.91 NASDAQ,ZION,1990-05-03,23.88,24.49,23.47,23.47,160000,1.90 NASDAQ,ZION,1990-05-02,24.08,24.49,23.88,24.49,87200,1.99 NASDAQ,ZION,1990-05-01,22.87,24.08,22.87,23.68,132000,1.92 NASDAQ,ZION,1990-04-30,23.47,23.88,23.47,23.88,20000,1.94 NASDAQ,ZION,1990-04-27,22.46,23.47,22.46,22.87,20000,1.86 NASDAQ,ZION,1990-04-26,23.47,23.47,23.47,23.47,1600,1.90 NASDAQ,ZION,1990-04-25,22.46,22.46,22.26,22.36,1924800,1.81 NASDAQ,ZION,1990-04-24,22.36,22.36,22.26,22.26,16000,1.81 NASDAQ,ZION,1990-04-23,22.06,22.46,22.06,22.46,18400,1.82 NASDAQ,ZION,1990-04-20,22.66,22.66,22.06,22.26,124800,1.81 NASDAQ,ZION,1990-04-19,22.66,22.66,22.26,22.56,441600,1.83 NASDAQ,ZION,1990-04-18,22.66,22.77,22.26,22.66,258400,1.84 NASDAQ,ZION,1990-04-17,22.26,22.46,22.26,22.26,72000,1.81 NASDAQ,ZION,1990-04-16,22.26,22.56,22.26,22.46,33600,1.82 NASDAQ,ZION,1990-04-12,22.26,22.66,22.26,22.26,53600,1.81 NASDAQ,ZION,1990-04-11,22.26,22.46,21.85,22.46,171200,1.82 NASDAQ,ZION,1990-04-10,22.26,22.26,21.85,21.85,6400,1.77 NASDAQ,ZION,1990-04-09,21.85,21.85,21.85,21.85,10400,1.77 NASDAQ,ZION,1990-04-06,22.26,22.26,21.85,21.85,285600,1.77 NASDAQ,ZION,1990-04-05,22.66,22.66,22.26,22.26,98400,1.81 NASDAQ,ZION,1990-04-04,23.07,23.07,22.26,22.26,65600,1.81 NASDAQ,ZION,1990-04-02,22.56,22.56,22.46,22.46,72000,1.82 NASDAQ,ZION,1990-03-30,22.06,22.06,22.06,22.06,800,1.79 NASDAQ,ZION,1990-03-29,22.66,22.66,22.46,22.46,26400,1.82 NASDAQ,ZION,1990-03-28,22.46,22.66,22.06,22.46,46400,1.82 NASDAQ,ZION,1990-03-26,22.06,22.46,22.06,22.46,21600,1.82 综上，hive查询数据表stocks中的相关数据时，相当于把一个大文件分块，然后分成若干个小文件块，再由jobtraker分配给各个tasktraker节点进行MapReduce处理,并不是把数据存到相关表中，只是将文件移植到hdfs文件系统上用hadoop MapReduce进行分析后将结果返回给查询用户. Namely, Hive仅仅担当了将SQL语句转变为MapReduce所处理的相关形式，如有总结error,欢迎指正，不过后面会持续update.