verified on Traf 1.1.0rc0 build: SQL>update statistics for table hive.tpch2x.customer on every column; --- SQL operation complete.
SQL>showstats for table hive.tpch2x.customer on existing columns;
Histogram data for Table HIVE.TPCH2X.CUSTOMER Table ID: 0
Hist ID # Ints Rowcount UEC Colname(s) ========== ====== =========== =========== =========================== 1864945772 25 300000 25 C_NATIONKEY 1864945777 62 300000 300000 C_ADDRESS 1864945782 62 300000 300000 C_NAME 1864945787 48 300000 300000 C_CUSTKEY 1864945791 62 300000 280754 C_COMMENT 1864945796 5 300000 5 C_MKTSEGMENT 1864945801 36 300000 262499 C_ACCTBAL 1864945806 62 300000 300000 C_PHONE
--- SQL operation complete.
verified on Traf 1.1.0rc0 build: customer on every column;
SQL>update statistics for table hive.tpch2x.
--- SQL operation complete.
SQL>showstats for table hive.tpch2x. customer on existing columns;
Histogram data for Table HIVE.TPCH2X. CUSTOMER
Table ID: 0
Hist ID # Ints Rowcount UEC Colname(s) ======= ======= ======
========== ====== =========== =========== =======
1864945772 25 300000 25 C_NATIONKEY
1864945777 62 300000 300000 C_ADDRESS
1864945782 62 300000 300000 C_NAME
1864945787 48 300000 300000 C_CUSTKEY
1864945791 62 300000 280754 C_COMMENT
1864945796 5 300000 5 C_MKTSEGMENT
1864945801 36 300000 262499 C_ACCTBAL
1864945806 62 300000 300000 C_PHONE
--- SQL operation complete.