[ 
https://issues.apache.org/jira/browse/HIVE-1648?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12970009#action_12970009
 ] 

Namit Jain commented on HIVE-1648:
----------------------------------

1. QBParseInfo: add setDestToLimit() for symmetry()
2. I am not sure any of your tests are working - set hive.stats.autogather = 
false
before you create the tables for which you want the stats to be populated while 
reading.

Clearly, this is the reason why piggyback_part.q is working.

2. piggyback_join.q

End:


show table extended like piggy_table3;
drop table piggy_table;


Add:

show table extended like piggy_table1;
show table extended like piggy_table2;


Also, add a test where you are joining:

piggyback_table1 a join
piggyback_table2 b on a.key = b.key join
piggyback_table3 c b.key = c.key

and then show table extended all the 3 tables.

3. piggyback_limit.q
add:

show table extended like piggy_table1;


before the end.
It should have no stats

4. piggbyback_subq.q and _union.q are wrong - you need to create new tables,
and then show table extended them at the end, just like other tests.

5.


> Automatically gathering stats when reading a table/partition
> ------------------------------------------------------------
>
>                 Key: HIVE-1648
>                 URL: https://issues.apache.org/jira/browse/HIVE-1648
>             Project: Hive
>          Issue Type: Sub-task
>            Reporter: Ning Zhang
>            Assignee: Paul Butler
>         Attachments: HIVE-1648.2.patch, HIVE-1648.3.patch, HIVE-1648.4.patch, 
> HIVE-1648.5.patch, HIVE-1648.patch, hive-1648.svn.patch
>
>
> HIVE-1361 introduces a new command 'ANALYZE TABLE T COMPUTE STATISTICS' to 
> gathering stats. This requires additional scan of the data. Stats gathering 
> can be piggy-backed on TableScanOperator whenever a table/partition is 
> scanned (given not LIMIT operator). 

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply via email to