[jira] [Commented] (HIVE-7384) Research into reduce-side join [Spark Branch]

[ https://issues.apache.org/jira/browse/HIVE-7384?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14105301#comment-14105301 ] Lianhui Wang commented on HIVE-7384: i think current spark already support hash by

[jira] [Commented] (HIVE-7384) Research into reduce-side join [Spark Branch]

[ https://issues.apache.org/jira/browse/HIVE-7384?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14106343#comment-14106343 ] Lianhui Wang commented on HIVE-7384: @Szehon Ho yes,i read OrderedRDDFunctions code and

[jira] [Commented] (HIVE-7384) Research into reduce-side join [Spark Branch]

[ https://issues.apache.org/jira/browse/HIVE-7384?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14106407#comment-14106407 ] Lianhui Wang commented on HIVE-7384: i think the thoughts is same as ideas that you

[jira] [Commented] (HIVE-3430) group by followed by join with the same key should be optimized

[ https://issues.apache.org/jira/browse/HIVE-3430?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13717883#comment-13717883 ] Lianhui Wang commented on HIVE-3430: Yin Huai,very nice work! group

[jira] [Commented] (HIVE-4506) use one map reduce to join multiple small tables

[ https://issues.apache.org/jira/browse/HIVE-4506?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13650371#comment-13650371 ] Lianhui Wang commented on HIVE-4506: Fern, can you provide your sql? if these tables

[jira] [Commented] (HIVE-4506) use one map reduce to join multiple small tables

[ https://issues.apache.org/jira/browse/HIVE-4506?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13650380#comment-13650380 ] Lianhui Wang commented on HIVE-4506: if these have difference column, HIVE-3784

[jira] [Commented] (HIVE-4429) Nested ORDER BY produces incorrect result

[ https://issues.apache.org/jira/browse/HIVE-4429?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13643453#comment-13643453 ] Lianhui Wang commented on HIVE-4429: hi, Mihir Kulkarni i run the first sql of your

[jira] [Commented] (HIVE-4365) wrong result in left semi join

[ https://issues.apache.org/jira/browse/HIVE-4365?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13633664#comment-13633664 ] Lianhui Wang commented on HIVE-4365: hi,ransom problem also exist in my environment.

[jira] [Commented] (HIVE-3963) Allow Hive to connect to RDBMS

[ https://issues.apache.org/jira/browse/HIVE-3963?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13596639#comment-13596639 ] Lianhui Wang commented on HIVE-3963: i think that must support as clause like transform

[jira] [Commented] (HIVE-4137) optimize group by followed by joins for bucketed/sorted tables

[ https://issues.apache.org/jira/browse/HIVE-4137?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13596690#comment-13596690 ] Lianhui Wang commented on HIVE-4137: in addition. for bucketed/sorted tables, for

[jira] [Commented] (HIVE-3430) group by followed by join with the same key should be optimized

[ https://issues.apache.org/jira/browse/HIVE-3430?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13590321#comment-13590321 ] Lianhui Wang commented on HIVE-3430: also should consider the following query: SELECT

[jira] [Commented] (HIVE-4014) Hive+RCFile is not doing column pruning and reading much more data than necessary

[ https://issues.apache.org/jira/browse/HIVE-4014?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13589226#comment-13589226 ] Lianhui Wang commented on HIVE-4014: hi,Tamas thank you very much,you are right. also i

[jira] [Commented] (HIVE-4014) Hive+RCFile is not doing column pruning and reading much more data than necessary

[ https://issues.apache.org/jira/browse/HIVE-4014?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13586701#comment-13586701 ] Lianhui Wang commented on HIVE-4014: i donot think that. i see the code. in

[jira] [Commented] (HIVE-3420) Inefficiency in hbase handler when process query including rowkey range scan

[ https://issues.apache.org/jira/browse/HIVE-3420?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13482075#comment-13482075 ] Lianhui Wang commented on HIVE-3420: @Gong Deng yes,i agree with you.in InputFormat

[jira] [Commented] (HIVE-1643) support range scans and non-key columns in HBase filter pushdown

[ https://issues.apache.org/jira/browse/HIVE-1643?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13482080#comment-13482080 ] Lianhui Wang commented on HIVE-1643: Ashutosh Chauhan Is this correct? What about

[jira] [Commented] (HIVE-3561) Build a full SQL-compliant parser for Hive

[ https://issues.apache.org/jira/browse/HIVE-3561?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13473167#comment-13473167 ] Lianhui Wang commented on HIVE-3561: for the first approach,there is a problem.

[jira] [Commented] (HIVE-3472) Build An Analytical SQL Engine for MapReduce

[ https://issues.apache.org/jira/browse/HIVE-3472?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13462391#comment-13462391 ] Lianhui Wang commented on HIVE-3472: nexr have done some works in oracle sql to hive

[jira] [Created] (HIVE-3329) Support bucket filtering when where expression or join key expression has the bucket key

Lianhui Wang created HIVE-3329: -- Summary: Support bucket filtering when where expression or join key expression has the bucket key Key: HIVE-3329 URL: https://issues.apache.org/jira/browse/HIVE-3329

[jira] [Commented] (HIVE-3306) SMBJoin/BucketMapJoin should be allowed only when join key expression is exactly matches with sort/cluster key

[ https://issues.apache.org/jira/browse/HIVE-3306?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13427127#comment-13427127 ] Lianhui Wang commented on HIVE-3306: @Namit, i created a new jira HIVE-3329, maybe

[jira] [Commented] (HIVE-3254) Reuse RunningJob

[ https://issues.apache.org/jira/browse/HIVE-3254?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13424569#comment-13424569 ] Lianhui Wang commented on HIVE-3254: yes, i think that can do. but maybe the newRj is

[jira] [Commented] (HIVE-942) use bucketing for group by

[ https://issues.apache.org/jira/browse/HIVE-942?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13404730#comment-13404730 ] Lianhui Wang commented on HIVE-942: --- i think in HIVE-931 ,the group by keys must be the