Hi Vijay,
Yes for this tables, ACID enabled. it has only 256 files for each buckets.
these are create only when data initially loaded in this table.
There is not transaction done after that.
I see that all file for buckets are also in equal size.
One thing that I am not able to understand that its is running with 1
MAPPER.
I will try options you provided , will get insight after that.
Please find below response of command "dfs -ls <path>"
dfs -ls /apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570;
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--+
|
DFS Output
|
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--+
| Found 256 items
|
| -rw-r--r-- 3 H56473 hdfs 215973009 2016-06-23 17:38
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00000
|
| -rw-r--r-- 3 H56473 hdfs 215253561 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00001
|
| -rw-r--r-- 3 H56473 hdfs 215470193 2016-06-23 17:40
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00002
|
| -rw-r--r-- 3 H56473 hdfs 215455699 2016-06-23 17:38
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00003
|
| -rw-r--r-- 3 H56473 hdfs 215620935 2016-06-23 17:38
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00004
|
| -rw-r--r-- 3 H56473 hdfs 215704945 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00005
|
| -rw-r--r-- 3 H56473 hdfs 215842552 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00006
|
| -rw-r--r-- 3 H56473 hdfs 215808371 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00007
|
| -rw-r--r-- 3 H56473 hdfs 215969399 2016-06-23 17:39
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00008
|
| -rw-r--r-- 3 H56473 hdfs 216130285 2016-06-23 17:39
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00009
|
| -rw-r--r-- 3 H56473 hdfs 216168481 2016-06-23 17:40
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00010
|
| -rw-r--r-- 3 H56473 hdfs 216152569 2016-06-23 17:39
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00011
|
| -rw-r--r-- 3 H56473 hdfs 216088033 2016-06-23 17:38
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00012
|
| -rw-r--r-- 3 H56473 hdfs 216264972 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00013
|
| -rw-r--r-- 3 H56473 hdfs 216267772 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00014
|
| -rw-r--r-- 3 H56473 hdfs 216385428 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00015
|
| -rw-r--r-- 3 H56473 hdfs 216399617 2016-06-23 17:38
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00016
|
| -rw-r--r-- 3 H56473 hdfs 216544838 2016-06-23 17:40
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00017
|
| -rw-r--r-- 3 H56473 hdfs 216542321 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00018
|
| -rw-r--r-- 3 H56473 hdfs 216520174 2016-06-23 17:40
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00019
|
| -rw-r--r-- 3 H56473 hdfs 216513782 2016-06-23 17:39
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00020
|
| -rw-r--r-- 3 H56473 hdfs 216546732 2016-06-23 17:40
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00021
|
| -rw-r--r-- 3 H56473 hdfs 216474592 2016-06-23 17:38
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00022
|
| -rw-r--r-- 3 H56473 hdfs 216503547 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00023
|
| -rw-r--r-- 3 H56473 hdfs 216590266 2016-06-23 17:39
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00024
|
| -rw-r--r-- 3 H56473 hdfs 216692713 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00025
|
| -rw-r--r-- 3 H56473 hdfs 216593362 2016-06-23 17:38
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00026
|
| -rw-r--r-- 3 H56473 hdfs 216736077 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00027
|
| -rw-r--r-- 3 H56473 hdfs 216691738 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00028
|
| -rw-r--r-- 3 H56473 hdfs 216751031 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00029
|
| -rw-r--r-- 3 H56473 hdfs 216748097 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00030
|
| -rw-r--r-- 3 H56473 hdfs 216561861 2016-06-23 17:38
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00031
|
| -rw-r--r-- 3 H56473 hdfs 216827688 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00032
|
| -rw-r--r-- 3 H56473 hdfs 216785788 2016-06-23 17:38
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00033
|
| -rw-r--r-- 3 H56473 hdfs 216824525 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00034
|
| -rw-r--r-- 3 H56473 hdfs 216744531 2016-06-23 17:38
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00035
|
| -rw-r--r-- 3 H56473 hdfs 216801179 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00036
|
| -rw-r--r-- 3 H56473 hdfs 216843923 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00037
|
| -rw-r--r-- 3 H56473 hdfs 216841512 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00038
|
| -rw-r--r-- 3 H56473 hdfs 216786403 2016-06-23 17:39
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00039
|
| -rw-r--r-- 3 H56473 hdfs 216828047 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00040
|
| -rw-r--r-- 3 H56473 hdfs 216825787 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00041
|
| -rw-r--r-- 3 H56473 hdfs 216876891 2016-06-23 17:38
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00042
|
| -rw-r--r-- 3 H56473 hdfs 216955603 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00043
|
| -rw-r--r-- 3 H56473 hdfs 216875485 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00044
|
| -rw-r--r-- 3 H56473 hdfs 216935044 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00045
|
| -rw-r--r-- 3 H56473 hdfs 216819647 2016-06-23 17:38
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00046
|
| -rw-r--r-- 3 H56473 hdfs 216951906 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00047
|
| -rw-r--r-- 3 H56473 hdfs 216992043 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00048
|
| -rw-r--r-- 3 H56473 hdfs 216893267 2016-06-23 17:38
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00049
|
| -rw-r--r-- 3 H56473 hdfs 216887568 2016-06-23 17:43
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00050
|
| -rw-r--r-- 3 H56473 hdfs 216932512 2016-06-23 17:40
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00051
|
| -rw-r--r-- 3 H56473 hdfs 216995951 2016-06-23 17:43
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00052
|
| -rw-r--r-- 3 H56473 hdfs 216980201 2016-06-23 17:43
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00053
|
| -rw-r--r-- 3 H56473 hdfs 217022321 2016-06-23 17:43
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00054
|
| -rw-r--r-- 3 H56473 hdfs 217061082 2016-06-23 17:43
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00055
|
| -rw-r--r-- 3 H56473 hdfs 216915085 2016-06-23 17:43
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00056
|
| -rw-r--r-- 3 H56473 hdfs 216973899 2016-06-23 17:43
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00057
|
| -rw-r--r-- 3 H56473 hdfs 216947693 2016-06-23 17:43
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00058
|
| -rw-r--r-- 3 H56473 hdfs 216978410 2016-06-23 17:43
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00059
|
| -rw-r--r-- 3 H56473 hdfs 216966029 2016-06-23 17:43
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00060
|
| -rw-r--r-- 3 H56473 hdfs 217062158 2016-06-23 17:43
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00061
|
| -rw-r--r-- 3 H56473 hdfs 217012664 2016-06-23 17:43
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00062
|
| -rw-r--r-- 3 H56473 hdfs 217126561 2016-06-23 17:43
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00063
|
| -rw-r--r-- 3 H56473 hdfs 217066999 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00064
|
| -rw-r--r-- 3 H56473 hdfs 217052347 2016-06-23 17:43
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00065
|
| -rw-r--r-- 3 H56473 hdfs 217054965 2016-06-23 17:43
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00066
|
| -rw-r--r-- 3 H56473 hdfs 217155817 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00067
|
| -rw-r--r-- 3 H56473 hdfs 217163685 2016-06-23 17:43
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00068
|
| -rw-r--r-- 3 H56473 hdfs 217075833 2016-06-23 17:44
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00069
|
| -rw-r--r-- 3 H56473 hdfs 217110271 2016-06-23 17:43
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00070
|
| -rw-r--r-- 3 H56473 hdfs 217099877 2016-06-23 17:43
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00071
|
| -rw-r--r-- 3 H56473 hdfs 217015698 2016-06-23 17:43
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00072
|
| -rw-r--r-- 3 H56473 hdfs 217077120 2016-06-23 17:43
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00073
|
| -rw-r--r-- 3 H56473 hdfs 216985477 2016-06-23 17:39
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00074
|
| -rw-r--r-- 3 H56473 hdfs 217026304 2016-06-23 17:43
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00075
|
| -rw-r--r-- 3 H56473 hdfs 217071942 2016-06-23 17:43
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00076
|
| -rw-r--r-- 3 H56473 hdfs 217043625 2016-06-23 17:43
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00077
|
| -rw-r--r-- 3 H56473 hdfs 217065652 2016-06-23 17:43
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00078
|
| -rw-r--r-- 3 H56473 hdfs 217016300 2016-06-23 17:43
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00079
|
| -rw-r--r-- 3 H56473 hdfs 216937153 2016-06-23 17:43
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00080
|
| -rw-r--r-- 3 H56473 hdfs 217133015 2016-06-23 17:43
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00081
|
| -rw-r--r-- 3 H56473 hdfs 217200238 2016-06-23 17:38
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00082
|
| -rw-r--r-- 3 H56473 hdfs 217054759 2016-06-23 17:43
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00083
|
| -rw-r--r-- 3 H56473 hdfs 217009417 2016-06-23 17:43
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00084
|
| -rw-r--r-- 3 H56473 hdfs 217120440 2016-06-23 17:43
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00085
|
| -rw-r--r-- 3 H56473 hdfs 216987824 2016-06-23 17:43
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00086
|
| -rw-r--r-- 3 H56473 hdfs 217053581 2016-06-23 17:43
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00087
|
| -rw-r--r-- 3 H56473 hdfs 217139935 2016-06-23 17:43
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00088
|
| -rw-r--r-- 3 H56473 hdfs 217133938 2016-06-23 17:43
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00089
|
| -rw-r--r-- 3 H56473 hdfs 217082768 2016-06-23 17:43
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00090
|
| -rw-r--r-- 3 H56473 hdfs 217163033 2016-06-23 17:43
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00091
|
| -rw-r--r-- 3 H56473 hdfs 217160879 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00092
|
| -rw-r--r-- 3 H56473 hdfs 217118996 2016-06-23 17:39
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00093
|
| -rw-r--r-- 3 H56473 hdfs 217075658 2016-06-23 17:38
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00094
|
| -rw-r--r-- 3 H56473 hdfs 217155885 2016-06-23 17:43
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00095
|
| -rw-r--r-- 3 H56473 hdfs 217073602 2016-06-23 17:43
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00096
|
| -rw-r--r-- 3 H56473 hdfs 217048454 2016-06-23 17:43
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00097
|
| -rw-r--r-- 3 H56473 hdfs 217073480 2016-06-23 17:38
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00098
|
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--+
|
DFS Output
|
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--+
| -rw-r--r-- 3 H56473 hdfs 217008473 2016-06-23 17:38
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00099
|
| -rw-r--r-- 3 H56473 hdfs 217055083 2016-06-23 17:38
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00100
|
| -rw-r--r-- 3 H56473 hdfs 217170178 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00101
|
| -rw-r--r-- 3 H56473 hdfs 217231866 2016-06-23 17:38
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00102
|
| -rw-r--r-- 3 H56473 hdfs 217065415 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00103
|
| -rw-r--r-- 3 H56473 hdfs 217082898 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00104
|
| -rw-r--r-- 3 H56473 hdfs 217091916 2016-06-23 17:38
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00105
|
| -rw-r--r-- 3 H56473 hdfs 217104784 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00106
|
| -rw-r--r-- 3 H56473 hdfs 217230988 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00107
|
| -rw-r--r-- 3 H56473 hdfs 217165086 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00108
|
| -rw-r--r-- 3 H56473 hdfs 217182369 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00109
|
| -rw-r--r-- 3 H56473 hdfs 217118862 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00110
|
| -rw-r--r-- 3 H56473 hdfs 217180020 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00111
|
| -rw-r--r-- 3 H56473 hdfs 217208232 2016-06-23 17:39
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00112
|
| -rw-r--r-- 3 H56473 hdfs 217199476 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00113
|
| -rw-r--r-- 3 H56473 hdfs 217059597 2016-06-23 17:39
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00114
|
| -rw-r--r-- 3 H56473 hdfs 217198679 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00115
|
| -rw-r--r-- 3 H56473 hdfs 217091012 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00116
|
| -rw-r--r-- 3 H56473 hdfs 217190091 2016-06-23 17:38
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00117
|
| -rw-r--r-- 3 H56473 hdfs 217212151 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00118
|
| -rw-r--r-- 3 H56473 hdfs 217177634 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00119
|
| -rw-r--r-- 3 H56473 hdfs 217173936 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00120
|
| -rw-r--r-- 3 H56473 hdfs 217091743 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00121
|
| -rw-r--r-- 3 H56473 hdfs 217141298 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00122
|
| -rw-r--r-- 3 H56473 hdfs 217132204 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00123
|
| -rw-r--r-- 3 H56473 hdfs 217246598 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00124
|
| -rw-r--r-- 3 H56473 hdfs 217151074 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00125
|
| -rw-r--r-- 3 H56473 hdfs 217159300 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00126
|
| -rw-r--r-- 3 H56473 hdfs 217065983 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00127
|
| -rw-r--r-- 3 H56473 hdfs 217193747 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00128
|
| -rw-r--r-- 3 H56473 hdfs 217228013 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00129
|
| -rw-r--r-- 3 H56473 hdfs 217375225 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00130
|
| -rw-r--r-- 3 H56473 hdfs 217335197 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00131
|
| -rw-r--r-- 3 H56473 hdfs 217182537 2016-06-23 17:39
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00132
|
| -rw-r--r-- 3 H56473 hdfs 217229480 2016-06-23 17:38
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00133
|
| -rw-r--r-- 3 H56473 hdfs 217283215 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00134
|
| -rw-r--r-- 3 H56473 hdfs 217372431 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00135
|
| -rw-r--r-- 3 H56473 hdfs 217234042 2016-06-23 17:38
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00136
|
| -rw-r--r-- 3 H56473 hdfs 217176898 2016-06-23 17:38
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00137
|
| -rw-r--r-- 3 H56473 hdfs 217301958 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00138
|
| -rw-r--r-- 3 H56473 hdfs 217451069 2016-06-23 17:39
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00139
|
| -rw-r--r-- 3 H56473 hdfs 217314824 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00140
|
| -rw-r--r-- 3 H56473 hdfs 217236714 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00141
|
| -rw-r--r-- 3 H56473 hdfs 217198689 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00142
|
| -rw-r--r-- 3 H56473 hdfs 217300105 2016-06-23 17:39
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00143
|
| -rw-r--r-- 3 H56473 hdfs 217322560 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00144
|
| -rw-r--r-- 3 H56473 hdfs 217251308 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00145
|
| -rw-r--r-- 3 H56473 hdfs 217268420 2016-06-23 17:39
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00146
|
| -rw-r--r-- 3 H56473 hdfs 217250943 2016-06-23 17:38
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00147
|
| -rw-r--r-- 3 H56473 hdfs 217317036 2016-06-23 17:39
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00148
|
| -rw-r--r-- 3 H56473 hdfs 217249339 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00149
|
| -rw-r--r-- 3 H56473 hdfs 217199279 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00150
|
| -rw-r--r-- 3 H56473 hdfs 217201217 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00151
|
| -rw-r--r-- 3 H56473 hdfs 217254531 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00152
|
| -rw-r--r-- 3 H56473 hdfs 217325584 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00153
|
| -rw-r--r-- 3 H56473 hdfs 217361150 2016-06-23 17:39
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00154
|
| -rw-r--r-- 3 H56473 hdfs 217108797 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00155
|
| -rw-r--r-- 3 H56473 hdfs 217250257 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00156
|
| -rw-r--r-- 3 H56473 hdfs 217207462 2016-06-23 17:39
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00157
|
| -rw-r--r-- 3 H56473 hdfs 217283114 2016-06-23 17:38
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00158
|
| -rw-r--r-- 3 H56473 hdfs 217336632 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00159
|
| -rw-r--r-- 3 H56473 hdfs 217240497 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00160
|
| -rw-r--r-- 3 H56473 hdfs 217253770 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00161
|
| -rw-r--r-- 3 H56473 hdfs 217304981 2016-06-23 17:40
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00162
|
| -rw-r--r-- 3 H56473 hdfs 217337919 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00163
|
| -rw-r--r-- 3 H56473 hdfs 217246615 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00164
|
| -rw-r--r-- 3 H56473 hdfs 217175520 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00165
|
| -rw-r--r-- 3 H56473 hdfs 217196985 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00166
|
| -rw-r--r-- 3 H56473 hdfs 217251912 2016-06-23 17:38
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00167
|
| -rw-r--r-- 3 H56473 hdfs 217220392 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00168
|
| -rw-r--r-- 3 H56473 hdfs 217197378 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00169
|
| -rw-r--r-- 3 H56473 hdfs 217348762 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00170
|
| -rw-r--r-- 3 H56473 hdfs 217328016 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00171
|
| -rw-r--r-- 3 H56473 hdfs 217142176 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00172
|
| -rw-r--r-- 3 H56473 hdfs 217184677 2016-06-23 17:40
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00173
|
| -rw-r--r-- 3 H56473 hdfs 217137840 2016-06-23 17:39
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00174
|
| -rw-r--r-- 3 H56473 hdfs 217256754 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00175
|
| -rw-r--r-- 3 H56473 hdfs 217220424 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00176
|
| -rw-r--r-- 3 H56473 hdfs 217185562 2016-06-23 17:39
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00177
|
| -rw-r--r-- 3 H56473 hdfs 217194575 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00178
|
| -rw-r--r-- 3 H56473 hdfs 217188097 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00179
|
| -rw-r--r-- 3 H56473 hdfs 217158674 2016-06-23 17:39
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00180
|
| -rw-r--r-- 3 H56473 hdfs 217222821 2016-06-23 17:38
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00181
|
| -rw-r--r-- 3 H56473 hdfs 217170798 2016-06-23 17:40
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00182
|
| -rw-r--r-- 3 H56473 hdfs 217112615 2016-06-23 17:39
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00183
|
| -rw-r--r-- 3 H56473 hdfs 217247444 2016-06-23 17:38
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00184
|
| -rw-r--r-- 3 H56473 hdfs 217136592 2016-06-23 17:39
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00185
|
| -rw-r--r-- 3 H56473 hdfs 217142003 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00186
|
| -rw-r--r-- 3 H56473 hdfs 217125721 2016-06-23 17:38
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00187
|
| -rw-r--r-- 3 H56473 hdfs 217223243 2016-06-23 17:40
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00188
|
| -rw-r--r-- 3 H56473 hdfs 217130702 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00189
|
| -rw-r--r-- 3 H56473 hdfs 217183947 2016-06-23 17:39
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00190
|
| -rw-r--r-- 3 H56473 hdfs 216992034 2016-06-23 17:39
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00191
|
| -rw-r--r-- 3 H56473 hdfs 217092469 2016-06-23 17:39
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00192
|
| -rw-r--r-- 3 H56473 hdfs 217105133 2016-06-23 17:39
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00193
|
| -rw-r--r-- 3 H56473 hdfs 217004917 2016-06-23 17:38
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00194
|
| -rw-r--r-- 3 H56473 hdfs 217078557 2016-06-23 17:40
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00195
|
| -rw-r--r-- 3 H56473 hdfs 217142035 2016-06-23 17:38
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00196
|
| -rw-r--r-- 3 H56473 hdfs 216993711 2016-06-23 17:38
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00197
|
| -rw-r--r-- 3 H56473 hdfs 217113515 2016-06-23 17:38
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00198
|
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--+
|
DFS Output
|
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--+
| -rw-r--r-- 3 H56473 hdfs 216982052 2016-06-23 17:38
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00199
|
| -rw-r--r-- 3 H56473 hdfs 217086795 2016-06-23 17:38
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00200
|
| -rw-r--r-- 3 H56473 hdfs 217093281 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00201
|
| -rw-r--r-- 3 H56473 hdfs 217019781 2016-06-23 17:38
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00202
|
| -rw-r--r-- 3 H56473 hdfs 217042372 2016-06-23 17:39
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00203
|
| -rw-r--r-- 3 H56473 hdfs 217057324 2016-06-23 17:40
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00204
|
| -rw-r--r-- 3 H56473 hdfs 216952020 2016-06-23 17:38
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00205
|
| -rw-r--r-- 3 H56473 hdfs 217032930 2016-06-23 17:39
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00206
|
| -rw-r--r-- 3 H56473 hdfs 217092936 2016-06-23 17:39
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00207
|
| -rw-r--r-- 3 H56473 hdfs 216983923 2016-06-23 17:38
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00208
|
| -rw-r--r-- 3 H56473 hdfs 216968290 2016-06-23 17:39
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00209
|
| -rw-r--r-- 3 H56473 hdfs 217005680 2016-06-23 17:39
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00210
|
| -rw-r--r-- 3 H56473 hdfs 216967777 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00211
|
| -rw-r--r-- 3 H56473 hdfs 217012052 2016-06-23 17:39
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00212
|
| -rw-r--r-- 3 H56473 hdfs 217030822 2016-06-23 17:38
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00213
|
| -rw-r--r-- 3 H56473 hdfs 216879098 2016-06-23 17:40
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00214
|
| -rw-r--r-- 3 H56473 hdfs 216938981 2016-06-23 17:38
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00215
|
| -rw-r--r-- 3 H56473 hdfs 216888064 2016-06-23 17:39
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00216
|
| -rw-r--r-- 3 H56473 hdfs 217006890 2016-06-23 17:38
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00217
|
| -rw-r--r-- 3 H56473 hdfs 216882204 2016-06-23 17:38
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00218
|
| -rw-r--r-- 3 H56473 hdfs 216878124 2016-06-23 17:40
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00219
|
| -rw-r--r-- 3 H56473 hdfs 216924030 2016-06-23 17:38
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00220
|
| -rw-r--r-- 3 H56473 hdfs 216870359 2016-06-23 17:38
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00221
|
| -rw-r--r-- 3 H56473 hdfs 216965696 2016-06-23 17:39
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00222
|
| -rw-r--r-- 3 H56473 hdfs 216835873 2016-06-23 17:38
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00223
|
| -rw-r--r-- 3 H56473 hdfs 216901023 2016-06-23 17:38
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00224
|
| -rw-r--r-- 3 H56473 hdfs 216800511 2016-06-23 17:38
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00225
|
| -rw-r--r-- 3 H56473 hdfs 216831982 2016-06-23 17:38
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00226
|
| -rw-r--r-- 3 H56473 hdfs 216800692 2016-06-23 17:38
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00227
|
| -rw-r--r-- 3 H56473 hdfs 216857795 2016-06-23 17:38
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00228
|
| -rw-r--r-- 3 H56473 hdfs 216788102 2016-06-23 17:38
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00229
|
| -rw-r--r-- 3 H56473 hdfs 216853182 2016-06-23 17:39
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00230
|
| -rw-r--r-- 3 H56473 hdfs 216762991 2016-06-23 17:39
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00231
|
| -rw-r--r-- 3 H56473 hdfs 216757552 2016-06-23 17:38
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00232
|
| -rw-r--r-- 3 H56473 hdfs 216654495 2016-06-23 17:39
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00233
|
| -rw-r--r-- 3 H56473 hdfs 216588262 2016-06-23 17:38
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00234
|
| -rw-r--r-- 3 H56473 hdfs 216648141 2016-06-23 17:38
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00235
|
| -rw-r--r-- 3 H56473 hdfs 216687726 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00236
|
| -rw-r--r-- 3 H56473 hdfs 216613018 2016-06-23 17:39
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00237
|
| -rw-r--r-- 3 H56473 hdfs 216561040 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00238
|
| -rw-r--r-- 3 H56473 hdfs 216561957 2016-06-23 17:39
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00239
|
| -rw-r--r-- 3 H56473 hdfs 216508756 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00240
|
| -rw-r--r-- 3 H56473 hdfs 216416846 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00241
|
| -rw-r--r-- 3 H56473 hdfs 216404453 2016-06-23 17:39
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00242
|
| -rw-r--r-- 3 H56473 hdfs 216439975 2016-06-23 17:40
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00243
|
| -rw-r--r-- 3 H56473 hdfs 216347834 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00244
|
| -rw-r--r-- 3 H56473 hdfs 216338215 2016-06-23 17:39
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00245
|
| -rw-r--r-- 3 H56473 hdfs 216234103 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00246
|
| -rw-r--r-- 3 H56473 hdfs 216350621 2016-06-23 17:39
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00247
|
| -rw-r--r-- 3 H56473 hdfs 216290393 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00248
|
| -rw-r--r-- 3 H56473 hdfs 216131030 2016-06-23 17:38
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00249
|
| -rw-r--r-- 3 H56473 hdfs 216065350 2016-06-23 17:38
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00250
|
| -rw-r--r-- 3 H56473 hdfs 215942146 2016-06-23 17:38
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00251
|
| -rw-r--r-- 3 H56473 hdfs 215876602 2016-06-23 17:41
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00252
|
| -rw-r--r-- 3 H56473 hdfs 215906085 2016-06-23 17:38
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00253
|
| -rw-r--r-- 3 H56473 hdfs 215650113 2016-06-23 17:38
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00254
|
| -rw-r--r-- 3 H56473 hdfs 215941082 2016-06-23 17:38
/apps/hive/warehouse/PRDDB.db/tuning_dd_key/delta_0001570_0001570/bucket_00255
|
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--+
257 rows selected (0.065 seconds)
Regards
Sanjiv Singh
Mob : +091 9990-447-339
On Fri, Jun 24, 2016 at 6:16 PM, Gopal Vijayaraghavan <gop...@apache.org>
wrote:
>
>
> > Please help me on this....let me know you need other info.
>
> Are the ORC tables fully compacted? Looks like you're running a version of
> Hive-ACID, which does not perform well without compacting delta files.
>
> dfs -ls <path>;
>
> should tell you whether there are any delta_* files in the list.
>
> > | ACID table:true
> > |
> > | alias:tuning_dd_key
> > |
>
> Other than that, it does look like you have only 1 shuffle and if you did
> run this using Tez, I recommend using
>
> <https://github.com/apache/tez/tree/master/tez-tools/swimlanes>
>
> to find out the slowest task & find more information about it. You will
> get a diagram which looks like this
>
> <http://www.slideshare.net/t3rmin4t0r/tez8-ui-walkthrough/20>
>
>
> The longest bar of that is the slowest task. I have another version of it,
> which is unreleased yet (is a bit hard to explain) giving an image which
> looks like
>
> <
> http://people.apache.org/~gopalv/q21_suppliers_who_kept_orders_waiting.svg
> >
>
>
> <https://github.com/t3rmin4t0r/tez-swimlanes/blob/master/vertex.py>
>
> which is better at finding the 1-2 reducers skewing in a large DAG like
> q21 [1].
>
>
> Cheers,
> Gopal
> [1] -
> <
> http://people.apache.org/~gopalv/tpch-plans/q21_suppliers_who_kept_orders_
> waiting.svg>
>
>
>
