[jira] [Commented] (HIVE-13737) incorrect count when multiple inserts with union all

2016-05-26 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-13737?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15302342#comment-15302342 ] Ashutosh Chauhan commented on HIVE-13737: - yes. There are lots of improvements to address this

[jira] [Commented] (HIVE-13737) incorrect count when multiple inserts with union all

2016-05-26 Thread frank luo (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-13737?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15302324#comment-15302324 ] frank luo commented on HIVE-13737: -- turning stats off gives correct result. So it is a bug in

[jira] [Commented] (HIVE-13737) incorrect count when multiple inserts with union all

2016-05-26 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-13737?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15302310#comment-15302310 ] Ashutosh Chauhan commented on HIVE-13737: - StatsOptimizer is throwing query off. Try turning it

[jira] [Commented] (HIVE-13737) incorrect count when multiple inserts with union all

2016-05-26 Thread frank luo (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-13737?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15302294#comment-15302294 ] frank luo commented on HIVE-13737: -- hive> explain INSERT INTO TABLE test SELECT * from src UNION ALL

[jira] [Commented] (HIVE-13737) incorrect count when multiple inserts with union all

2016-05-26 Thread frank luo (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-13737?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15302296#comment-15302296 ] frank luo commented on HIVE-13737: -- forgot to mention I was using TEZ on Hive. > incorrect count when

[jira] [Commented] (HIVE-13737) incorrect count when multiple inserts with union all

2016-05-26 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-13737?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15302261#comment-15302261 ] Ashutosh Chauhan commented on HIVE-13737: - Can you add explain output? > incorrect count when

[jira] [Commented] (HIVE-13737) incorrect count when multiple inserts with union all

2016-05-26 Thread frank luo (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-13737?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15302252#comment-15302252 ] frank luo commented on HIVE-13737: -- it always gives wrong result. > incorrect count when multiple

[jira] [Commented] (HIVE-13737) incorrect count when multiple inserts with union all

2016-05-11 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-13737?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15280783#comment-15280783 ] Ashutosh Chauhan commented on HIVE-13737: - Is it the case that you get different results in