[jira] [Updated] (HIVE-16924) Support distinct in presence Gby

[ https://issues.apache.org/jira/browse/HIVE-16924?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated HIVE-16924: --- Attachment: HIVE-16924.02.patch > Support distinct in presence Gby >

[jira] [Updated] (HIVE-16924) Support distinct in presence Gby

[ https://issues.apache.org/jira/browse/HIVE-16924?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated HIVE-16924: --- Status: Patch Available (was: Open) Patch 2, based upon [https://github.com/julianhyde/hive/tree/169

[jira] [Commented] (HIVE-16924) Support distinct in presence Gby

[ https://issues.apache.org/jira/browse/HIVE-16924?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16353242#comment-16353242 ] Julian Hyde commented on HIVE-16924: Test failures so far: wrong_distinct1.q, global_l

[jira] [Commented] (HIVE-16924) Support distinct in presence Gby

[ https://issues.apache.org/jira/browse/HIVE-16924?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16359316#comment-16359316 ] Julian Hyde commented on HIVE-16924: Still running tests on my local machine. The only

[jira] [Updated] (HIVE-16924) Support distinct in presence Gby

[ https://issues.apache.org/jira/browse/HIVE-16924?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated HIVE-16924: --- Status: Open (was: Patch Available) > Support distinct in presence Gby > ---

[jira] [Updated] (HIVE-16924) Support distinct in presence Gby

[ https://issues.apache.org/jira/browse/HIVE-16924?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated HIVE-16924: --- Status: Patch Available (was: Open) > Support distinct in presence Gby > ---

[jira] [Updated] (HIVE-16924) Support distinct in presence Gby

[ https://issues.apache.org/jira/browse/HIVE-16924?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated HIVE-16924: --- Attachment: HIVE-16924.03.patch > Support distinct in presence Gby >

[jira] [Updated] (HIVE-16924) Support distinct in presence Gby

[ https://issues.apache.org/jira/browse/HIVE-16924?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated HIVE-16924: --- Status: Open (was: Patch Available) > Support distinct in presence Gby > ---

[jira] [Updated] (HIVE-16924) Support distinct in presence Gby

[ https://issues.apache.org/jira/browse/HIVE-16924?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated HIVE-16924: --- Status: Patch Available (was: Open) > Support distinct in presence Gby > ---

[jira] [Updated] (HIVE-16924) Support distinct in presence Gby

[ https://issues.apache.org/jira/browse/HIVE-16924?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated HIVE-16924: --- Attachment: HIVE-16924.04.patch > Support distinct in presence Gby >

[jira] [Commented] (HIVE-16924) Support distinct in presence Gby

[ https://issues.apache.org/jira/browse/HIVE-16924?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16361219#comment-16361219 ] Julian Hyde commented on HIVE-16924: [~ashutoshc], I have fixed various test failures,

[jira] [Updated] (HIVE-16924) Support distinct in presence Gby

[ https://issues.apache.org/jira/browse/HIVE-16924?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated HIVE-16924: --- Status: Open (was: Patch Available) > Support distinct in presence Gby > ---

[jira] [Updated] (HIVE-16924) Support distinct in presence Gby

[ https://issues.apache.org/jira/browse/HIVE-16924?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated HIVE-16924: --- Status: Patch Available (was: Open) > Support distinct in presence Gby > ---

[jira] [Updated] (HIVE-16924) Support distinct in presence Gby

[ https://issues.apache.org/jira/browse/HIVE-16924?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated HIVE-16924: --- Attachment: HIVE-16924.05.patch > Support distinct in presence Gby >

[jira] [Commented] (HIVE-16924) Support distinct in presence Gby

[ https://issues.apache.org/jira/browse/HIVE-16924?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16366125#comment-16366125 ] Julian Hyde commented on HIVE-16924: As of the latest patch, many tests on [~ashutoshc

[jira] [Updated] (HIVE-16924) Support distinct in presence Gby

[ https://issues.apache.org/jira/browse/HIVE-16924?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated HIVE-16924: --- Status: Open (was: Patch Available) > Support distinct in presence Gby > ---

[jira] [Updated] (HIVE-16924) Support distinct in presence Gby

[ https://issues.apache.org/jira/browse/HIVE-16924?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated HIVE-16924: --- Attachment: HIVE-16924.06.patch > Support distinct in presence Gby >

[jira] [Commented] (HIVE-16924) Support distinct in presence Gby

[ https://issues.apache.org/jira/browse/HIVE-16924?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16379190#comment-16379190 ] Julian Hyde commented on HIVE-16924: I added a new patch, HIVE-16924.06.patch, based u

[jira] [Commented] (HIVE-18423) Hive should support usage of external tables using jdbc

[ https://issues.apache.org/jira/browse/HIVE-18423?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16331159#comment-16331159 ] Julian Hyde commented on HIVE-18423: I'd like to comment on an raised in the review co

[jira] [Commented] (HIVE-17395) HiveServer2 parsing a command with a lot of "("

[ https://issues.apache.org/jira/browse/HIVE-17395?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16800973#comment-16800973 ] Julian Hyde commented on HIVE-17395: I'm running into this issue also, in my testing

[jira] [Commented] (HIVE-17395) HiveServer2 parsing a command with a lot of "("

[ https://issues.apache.org/jira/browse/HIVE-17395?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16802180#comment-16802180 ] Julian Hyde commented on HIVE-17395: [~kgyrtkirk] Thanks. I was aware of HIVE-15388 b

[jira] [Commented] (HIVE-17395) HiveServer2 parsing a command with a lot of "("

[ https://issues.apache.org/jira/browse/HIVE-17395?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16807152#comment-16807152 ] Julian Hyde commented on HIVE-17395: HIVE-17395 seems to be a duplicate of HIVE-18624

[jira] [Commented] (HIVE-22455) Union branch removal rule does not kick in.

[ https://issues.apache.org/jira/browse/HIVE-22455?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16967155#comment-16967155 ] Julian Hyde commented on HIVE-22455: There are a bunch of rules in Calcite's class Pr

[jira] [Commented] (HIVE-10667) Upgrade Calcite dependency to newest version

[ https://issues.apache.org/jira/browse/HIVE-10667?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14546879#comment-14546879 ] Julian Hyde commented on HIVE-10667: Thanks [~jcamachorodriguez]. I'll proceed with th

[jira] [Commented] (HIVE-10636) CASE comparison operator rotation optimization

[ https://issues.apache.org/jira/browse/HIVE-10636?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14549594#comment-14549594 ] Julian Hyde commented on HIVE-10636: If you wrap every WHERE clause predicate (and oth

[jira] [Commented] (HIVE-11165) Calcite planner might have a thread-safety issue compiling in parallel

[ https://issues.apache.org/jira/browse/HIVE-11165?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15269751#comment-15269751 ] Julian Hyde commented on HIVE-11165: I don't have an update. It's not obviously a thre

[jira] [Commented] (HIVE-11918) Implement/Enable constant related optimization rules in Calcite

[ https://issues.apache.org/jira/browse/HIVE-11918?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14935624#comment-14935624 ] Julian Hyde commented on HIVE-11918: [~pxiong], I have a tentative fix for CALCITE-902

[jira] [Commented] (HIVE-11918) Implement/Enable constant related optimization rules in Calcite

[ https://issues.apache.org/jira/browse/HIVE-11918?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14938254#comment-14938254 ] Julian Hyde commented on HIVE-11918: Thanks for confirming that the fix works. The cha

[jira] [Commented] (HIVE-11918) Implement/Enable constant related optimization rules in Calcite

[ https://issues.apache.org/jira/browse/HIVE-11918?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14939053#comment-14939053 ] Julian Hyde commented on HIVE-11918: Slight correction. If upgrading is hard, it might

[jira] [Commented] (HIVE-10332) Use SortExchange rather than LogicalExchange for HiveOpConverter

[ https://issues.apache.org/jira/browse/HIVE-10332?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14495820#comment-14495820 ] Julian Hyde commented on HIVE-10332: No reason to remove LogicalExchange from Calcite,

[jira] [Commented] (HIVE-25173) Fix build failure of hive-pre-upgrade due to missing dependency on pentaho-aggdesigner-algorithm

[ https://issues.apache.org/jira/browse/HIVE-25173?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17363800#comment-17363800 ] Julian Hyde commented on HIVE-25173: I made a release of this library under my groupi

[jira] [Commented] (HIVE-25173) Fix build failure of hive-pre-upgrade due to missing dependency on pentaho-aggdesigner-algorithm

[ https://issues.apache.org/jira/browse/HIVE-25173?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17366261#comment-17366261 ] Julian Hyde commented on HIVE-25173: It may be possible to bringing conjars back onli

[jira] [Commented] (HIVE-25173) Fix build failure of hive-pre-upgrade due to missing dependency on pentaho-aggdesigner-algorithm

[ https://issues.apache.org/jira/browse/HIVE-25173?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17366262#comment-17366262 ] Julian Hyde commented on HIVE-25173: Cc [~cwensel]. > Fix build failure of hive-pre-

[jira] [Commented] (HIVE-24902) Incorrect result due to ReduceExpressionsRule

[ https://issues.apache.org/jira/browse/HIVE-24902?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17304552#comment-17304552 ] Julian Hyde commented on HIVE-24902: Sorry, no. > Incorrect result due to ReduceExpr

[jira] [Updated] (HIVE-11383) Upgrade Hive to Calcite 1.4

[ https://issues.apache.org/jira/browse/HIVE-11383?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde updated HIVE-11383: --- Attachment: HIVE-11383.1.patch > Upgrade Hive to Calcite 1.4 > --- > >

[jira] [Commented] (HIVE-11383) Upgrade Hive to Calcite 1.4

[ https://issues.apache.org/jira/browse/HIVE-11383?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14643235#comment-14643235 ] Julian Hyde commented on HIVE-11383: By the way, the issue that needed to be fixed was

[jira] [Commented] (HIVE-11383) Upgrade Hive to Calcite 1.4

[ https://issues.apache.org/jira/browse/HIVE-11383?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14643270#comment-14643270 ] Julian Hyde commented on HIVE-11383: Agreed. We will not check in the patch as is. It

[jira] [Commented] (HIVE-15708) Upgrade calcite version to 1.11

[ https://issues.apache.org/jira/browse/HIVE-15708?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15843800#comment-15843800 ] Julian Hyde commented on HIVE-15708: [~elserj], Do you agree or disagree that a factor

[jira] [Commented] (HIVE-5873) SubQuery: In subquery Count Bug

[ https://issues.apache.org/jira/browse/HIVE-5873?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15864552#comment-15864552 ] Julian Hyde commented on HIVE-5873: --- This is fixed in Calcite as part of CALCITE-365. It'

[jira] [Commented] (HIVE-15996) Implement multiargument GROUPING function

[ https://issues.apache.org/jira/browse/HIVE-15996?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16033545#comment-16033545 ] Julian Hyde commented on HIVE-15996: I was mistaken about {{GROUP_ID()}} being equival

[jira] [Commented] (HIVE-12923) CBO: Calcite Operator To Hive Operator (Calcite Return Path): TestCliDriver groupby_grouping_sets4.q failure

[ https://issues.apache.org/jira/browse/HIVE-12923?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16043122#comment-16043122 ] Julian Hyde commented on HIVE-12923: I have created a pull request for CALCITE-1069. T

[jira] [Commented] (HIVE-13094) CBO: Assertion error in Case expression

[ https://issues.apache.org/jira/browse/HIVE-13094?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16234326#comment-16234326 ] Julian Hyde commented on HIVE-13094: [~jcamachorodriguez], Did this ever get ported to

[jira] [Assigned] (HIVE-16924) Support distinct in presence Gby

[ https://issues.apache.org/jira/browse/HIVE-16924?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Julian Hyde reassigned HIVE-16924: -- Assignee: Julian Hyde (was: Remus Rusanu) > Support distinct in presence Gby > --

[jira] [Commented] (HIVE-12640) Allow StatsOptimizer to optimize the query for Constant GroupBy keys

[ https://issues.apache.org/jira/browse/HIVE-12640?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15051586#comment-15051586 ] Julian Hyde commented on HIVE-12640: If {{src}} is empty, according to the SQL standar

[jira] [Commented] (HIVE-12839) Upgrade Hive to Calcite 1.6

[ https://issues.apache.org/jira/browse/HIVE-12839?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15128815#comment-15128815 ] Julian Hyde commented on HIVE-12839: [~pxiong], I was pretty sure I didn't add anythin

[jira] [Commented] (HIVE-12839) Upgrade Hive to Calcite 1.6

[ https://issues.apache.org/jira/browse/HIVE-12839?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15133973#comment-15133973 ] Julian Hyde commented on HIVE-12839: It's not essential, but I recommend storing RelMe

[jira] [Commented] (HIVE-15996) Implement multiargument GROUPING function

[ https://issues.apache.org/jira/browse/HIVE-15996?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15876628#comment-15876628 ] Julian Hyde commented on HIVE-15996: Is this behavior identical to the GROUP_ID functi

[jira] [Commented] (HIVE-15996) Implement multiargument GROUPING function

[ https://issues.apache.org/jira/browse/HIVE-15996?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15879040#comment-15879040 ] Julian Hyde commented on HIVE-15996: [~jcamachorodriguez] [~cartershanklin], Yes, I me

[jira] [Commented] (HIVE-12923) CBO: Calcite Operator To Hive Operator (Calcite Return Path): TestCliDriver groupby_grouping_sets4.q failure

[ https://issues.apache.org/jira/browse/HIVE-12923?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15879135#comment-15879135 ] Julian Hyde commented on HIVE-12923: I'm thinking of an alternative solution to CALCIT

[jira] [Commented] (HIVE-12923) CBO: Calcite Operator To Hive Operator (Calcite Return Path): TestCliDriver groupby_grouping_sets4.q failure

[ https://issues.apache.org/jira/browse/HIVE-12923?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15926833#comment-15926833 ] Julian Hyde commented on HIVE-12923: [~hsubramaniyan], [~jcamachorodriguez], Any thoug