The show create table table name (Anonymised): CREATE TABLE database_name.table_name ( a STRING, b STRING, c STRING, d STRING, e TIMESTAMP, f TIMESTAMP, g STRING, h TIMESTAMP, i STRING, j BIGINT, k STRING, l STRING, m STRING, n STRING, o STRING, p STRING, r STRING, s STRING, t STRING, x STRING, y TIMESTAMP, z STRING, aa STRING, bb STRING, cc STRING, dd STRING, ee STRING, ff BIGINT, gg BIGINT, hh TIMESTAMP, ii TIMESTAMP, jj STRING, kk STRING, ll STRING, mm STRING, nn STRING, oo STRING, oo STRING, pp STRING, qq STRING, rr STRING, ss STRING, tt STRING, uu STRING, xx STRING, yy STRING, zz STRING, aaa STRING, bbb STRING, ccc STRING, ddd STRING, eee STRING, fff BIGINT, ggg STRING, hhh STRING, iii STRING, jjj STRING, kkk STRING, lll STRING, mmm STRING, nnn STRING, ooo STRING, ppp STRING, qqq STRING, rrr STRING, sss STRING, ttt STRING, uuu STRING, xxx STRING, yyy STRING, zzz STRING )
PARTITIONED BY ( abc STRING, abcde STRING ) WITH SERDEPROPERTIES ('serialization.format'='1')
STORED AS TEXTFILE LOCATION 'hdfs://HaNameNode/user/hive/warehouse/database_name.db/table_name'
TBLPROPERTIES ('STATS_GENERATED_VIA_STATS_TASK'='true', 'transient_lastDdlTime'='1450869167', 'numRows'='106717515') Query: select count(distinct a, b, c, d, e),a
from table_name
group by a Impala error and logs: Bad status for request 9360: TGetOperationStatusResp(status=TStatus(errorCode=None, errorMessage=None, sqlState=None, infoMessages=None, statusCode=0), operationState=5, errorMessage=None, sqlState=None, errorCode=None)
Query 364e9ad30338567c:3bb748508f6431af: 33% Complete (1370 out of 4149)
Backend 6:For better performance, snappy, gzip and bzip-compressed files should not be split into multiple hdfs-blocks. file=hdfs://HaNameNode/user/hive/warehouse/database_name.db/table_name/abc=value_abc/abcd=2015-12/000000_0_copy_42.snappy offset 134217728
For better performance, snappy, gzip and bzip-compressed files should not be split into multiple hdfs-blocks. file=hdfs://HaNameNode/user/hive/warehouse/database_name.db/table_name/abc=value_abc/abcd=2015-12/000000_0_copy_41.snappy offset 134217728
For better performance, snappy, gzip and bzip-compressed files should not be split into multiple hdfs-blocks. file=hdfs://HaNameNode/user/hive/warehouse/database_name.db/table_name/abc=value_abc/abcd=2015-11/000001_0.snappy offset 134217728
Backend 7:For better performance, snappy, gzip and bzip-compressed files should not be split into multiple hdfs-blocks. file=hdfs://HaNameNode/user/hive/warehouse/database_name.db/table_name/abc=value_abc/abcd=2015-12/000000_0_copy_43.snappy offset 134217728
... View more
