[jira] [Updated] (HIVE-19674) Group by Decimal Constants push down to Druid tables.
[ https://issues.apache.org/jira/browse/HIVE-19674?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-19674: --- Resolution: Fixed Fix Version/s: 4.0.0 Status: Resolved (was: Patch Available) Pushed to master. > Group by Decimal Constants push down to Druid tables. > - > > Key: HIVE-19674 > URL: https://issues.apache.org/jira/browse/HIVE-19674 > Project: Hive > Issue Type: Improvement > Components: Druid integration >Reporter: slim bouguerra >Assignee: Vineet Garg >Priority: Major > Fix For: 4.0.0 > > Attachments: HIVE-19674.1.patch, HIVE-19674.2.patch, > HIVE-19674.3.patch, HIVE-19674.4.patch, HIVE-19674.5.patch, HIVE-19674.6.patch > > > Queries like following gets generated by Tableau. > {code} > SELECT SUM(`ssb_druid_100`.`lo_revenue`) AS `sum_lo_revenue_ok` > FROM `druid_ssb`.`ssb_druid_100` `ssb_druid_100` > GROUP BY 1.1001; > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-19674) Group by Decimal Constants push down to Druid tables.
[ https://issues.apache.org/jira/browse/HIVE-19674?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-19674: --- Status: Patch Available (was: Open) > Group by Decimal Constants push down to Druid tables. > - > > Key: HIVE-19674 > URL: https://issues.apache.org/jira/browse/HIVE-19674 > Project: Hive > Issue Type: Improvement > Components: Druid integration >Reporter: slim bouguerra >Assignee: Vineet Garg >Priority: Major > Attachments: HIVE-19674.1.patch, HIVE-19674.2.patch, > HIVE-19674.3.patch, HIVE-19674.4.patch, HIVE-19674.5.patch, HIVE-19674.6.patch > > > Queries like following gets generated by Tableau. > {code} > SELECT SUM(`ssb_druid_100`.`lo_revenue`) AS `sum_lo_revenue_ok` > FROM `druid_ssb`.`ssb_druid_100` `ssb_druid_100` > GROUP BY 1.1001; > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-19674) Group by Decimal Constants push down to Druid tables.
[ https://issues.apache.org/jira/browse/HIVE-19674?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-19674: --- Status: Open (was: Patch Available) > Group by Decimal Constants push down to Druid tables. > - > > Key: HIVE-19674 > URL: https://issues.apache.org/jira/browse/HIVE-19674 > Project: Hive > Issue Type: Improvement > Components: Druid integration >Reporter: slim bouguerra >Assignee: Vineet Garg >Priority: Major > Attachments: HIVE-19674.1.patch, HIVE-19674.2.patch, > HIVE-19674.3.patch, HIVE-19674.4.patch, HIVE-19674.5.patch, HIVE-19674.6.patch > > > Queries like following gets generated by Tableau. > {code} > SELECT SUM(`ssb_druid_100`.`lo_revenue`) AS `sum_lo_revenue_ok` > FROM `druid_ssb`.`ssb_druid_100` `ssb_druid_100` > GROUP BY 1.1001; > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-19674) Group by Decimal Constants push down to Druid tables.
[ https://issues.apache.org/jira/browse/HIVE-19674?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-19674: --- Attachment: HIVE-19674.6.patch > Group by Decimal Constants push down to Druid tables. > - > > Key: HIVE-19674 > URL: https://issues.apache.org/jira/browse/HIVE-19674 > Project: Hive > Issue Type: Improvement > Components: Druid integration >Reporter: slim bouguerra >Assignee: Vineet Garg >Priority: Major > Attachments: HIVE-19674.1.patch, HIVE-19674.2.patch, > HIVE-19674.3.patch, HIVE-19674.4.patch, HIVE-19674.5.patch, HIVE-19674.6.patch > > > Queries like following gets generated by Tableau. > {code} > SELECT SUM(`ssb_druid_100`.`lo_revenue`) AS `sum_lo_revenue_ok` > FROM `druid_ssb`.`ssb_druid_100` `ssb_druid_100` > GROUP BY 1.1001; > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-19674) Group by Decimal Constants push down to Druid tables.
[ https://issues.apache.org/jira/browse/HIVE-19674?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-19674: --- Status: Open (was: Patch Available) > Group by Decimal Constants push down to Druid tables. > - > > Key: HIVE-19674 > URL: https://issues.apache.org/jira/browse/HIVE-19674 > Project: Hive > Issue Type: Improvement > Components: Druid integration >Reporter: slim bouguerra >Assignee: Vineet Garg >Priority: Major > Attachments: HIVE-19674.1.patch, HIVE-19674.2.patch, > HIVE-19674.3.patch, HIVE-19674.4.patch, HIVE-19674.5.patch > > > Queries like following gets generated by Tableau. > {code} > SELECT SUM(`ssb_druid_100`.`lo_revenue`) AS `sum_lo_revenue_ok` > FROM `druid_ssb`.`ssb_druid_100` `ssb_druid_100` > GROUP BY 1.1001; > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-19674) Group by Decimal Constants push down to Druid tables.
[ https://issues.apache.org/jira/browse/HIVE-19674?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-19674: --- Status: Patch Available (was: Open) > Group by Decimal Constants push down to Druid tables. > - > > Key: HIVE-19674 > URL: https://issues.apache.org/jira/browse/HIVE-19674 > Project: Hive > Issue Type: Improvement > Components: Druid integration >Reporter: slim bouguerra >Assignee: Vineet Garg >Priority: Major > Attachments: HIVE-19674.1.patch, HIVE-19674.2.patch, > HIVE-19674.3.patch, HIVE-19674.4.patch, HIVE-19674.5.patch > > > Queries like following gets generated by Tableau. > {code} > SELECT SUM(`ssb_druid_100`.`lo_revenue`) AS `sum_lo_revenue_ok` > FROM `druid_ssb`.`ssb_druid_100` `ssb_druid_100` > GROUP BY 1.1001; > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-19674) Group by Decimal Constants push down to Druid tables.
[ https://issues.apache.org/jira/browse/HIVE-19674?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-19674: --- Attachment: HIVE-19674.5.patch > Group by Decimal Constants push down to Druid tables. > - > > Key: HIVE-19674 > URL: https://issues.apache.org/jira/browse/HIVE-19674 > Project: Hive > Issue Type: Improvement > Components: Druid integration >Reporter: slim bouguerra >Assignee: Vineet Garg >Priority: Major > Attachments: HIVE-19674.1.patch, HIVE-19674.2.patch, > HIVE-19674.3.patch, HIVE-19674.4.patch, HIVE-19674.5.patch > > > Queries like following gets generated by Tableau. > {code} > SELECT SUM(`ssb_druid_100`.`lo_revenue`) AS `sum_lo_revenue_ok` > FROM `druid_ssb`.`ssb_druid_100` `ssb_druid_100` > GROUP BY 1.1001; > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-19674) Group by Decimal Constants push down to Druid tables.
[ https://issues.apache.org/jira/browse/HIVE-19674?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-19674: --- Status: Open (was: Patch Available) > Group by Decimal Constants push down to Druid tables. > - > > Key: HIVE-19674 > URL: https://issues.apache.org/jira/browse/HIVE-19674 > Project: Hive > Issue Type: Improvement > Components: Druid integration >Reporter: slim bouguerra >Assignee: Vineet Garg >Priority: Major > Attachments: HIVE-19674.1.patch, HIVE-19674.2.patch, > HIVE-19674.3.patch, HIVE-19674.4.patch > > > Queries like following gets generated by Tableau. > {code} > SELECT SUM(`ssb_druid_100`.`lo_revenue`) AS `sum_lo_revenue_ok` > FROM `druid_ssb`.`ssb_druid_100` `ssb_druid_100` > GROUP BY 1.1001; > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-19674) Group by Decimal Constants push down to Druid tables.
[ https://issues.apache.org/jira/browse/HIVE-19674?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-19674: --- Status: Patch Available (was: Open) > Group by Decimal Constants push down to Druid tables. > - > > Key: HIVE-19674 > URL: https://issues.apache.org/jira/browse/HIVE-19674 > Project: Hive > Issue Type: Improvement > Components: Druid integration >Reporter: slim bouguerra >Assignee: Vineet Garg >Priority: Major > Attachments: HIVE-19674.1.patch, HIVE-19674.2.patch, > HIVE-19674.3.patch, HIVE-19674.4.patch > > > Queries like following gets generated by Tableau. > {code} > SELECT SUM(`ssb_druid_100`.`lo_revenue`) AS `sum_lo_revenue_ok` > FROM `druid_ssb`.`ssb_druid_100` `ssb_druid_100` > GROUP BY 1.1001; > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-19674) Group by Decimal Constants push down to Druid tables.
[ https://issues.apache.org/jira/browse/HIVE-19674?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-19674: --- Attachment: HIVE-19674.4.patch > Group by Decimal Constants push down to Druid tables. > - > > Key: HIVE-19674 > URL: https://issues.apache.org/jira/browse/HIVE-19674 > Project: Hive > Issue Type: Improvement > Components: Druid integration >Reporter: slim bouguerra >Assignee: Vineet Garg >Priority: Major > Attachments: HIVE-19674.1.patch, HIVE-19674.2.patch, > HIVE-19674.3.patch, HIVE-19674.4.patch > > > Queries like following gets generated by Tableau. > {code} > SELECT SUM(`ssb_druid_100`.`lo_revenue`) AS `sum_lo_revenue_ok` > FROM `druid_ssb`.`ssb_druid_100` `ssb_druid_100` > GROUP BY 1.1001; > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-19674) Group by Decimal Constants push down to Druid tables.
[ https://issues.apache.org/jira/browse/HIVE-19674?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-19674: --- Status: Patch Available (was: Open) > Group by Decimal Constants push down to Druid tables. > - > > Key: HIVE-19674 > URL: https://issues.apache.org/jira/browse/HIVE-19674 > Project: Hive > Issue Type: Improvement > Components: Druid integration >Reporter: slim bouguerra >Assignee: Vineet Garg >Priority: Major > Attachments: HIVE-19674.1.patch, HIVE-19674.2.patch, > HIVE-19674.3.patch > > > Queries like following gets generated by Tableau. > {code} > SELECT SUM(`ssb_druid_100`.`lo_revenue`) AS `sum_lo_revenue_ok` > FROM `druid_ssb`.`ssb_druid_100` `ssb_druid_100` > GROUP BY 1.1001; > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-19674) Group by Decimal Constants push down to Druid tables.
[ https://issues.apache.org/jira/browse/HIVE-19674?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-19674: --- Status: Open (was: Patch Available) > Group by Decimal Constants push down to Druid tables. > - > > Key: HIVE-19674 > URL: https://issues.apache.org/jira/browse/HIVE-19674 > Project: Hive > Issue Type: Improvement > Components: Druid integration >Reporter: slim bouguerra >Assignee: Vineet Garg >Priority: Major > Attachments: HIVE-19674.1.patch, HIVE-19674.2.patch, > HIVE-19674.3.patch > > > Queries like following gets generated by Tableau. > {code} > SELECT SUM(`ssb_druid_100`.`lo_revenue`) AS `sum_lo_revenue_ok` > FROM `druid_ssb`.`ssb_druid_100` `ssb_druid_100` > GROUP BY 1.1001; > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-19674) Group by Decimal Constants push down to Druid tables.
[ https://issues.apache.org/jira/browse/HIVE-19674?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-19674: --- Attachment: HIVE-19674.3.patch > Group by Decimal Constants push down to Druid tables. > - > > Key: HIVE-19674 > URL: https://issues.apache.org/jira/browse/HIVE-19674 > Project: Hive > Issue Type: Improvement > Components: Druid integration >Reporter: slim bouguerra >Assignee: Vineet Garg >Priority: Major > Attachments: HIVE-19674.1.patch, HIVE-19674.2.patch, > HIVE-19674.3.patch > > > Queries like following gets generated by Tableau. > {code} > SELECT SUM(`ssb_druid_100`.`lo_revenue`) AS `sum_lo_revenue_ok` > FROM `druid_ssb`.`ssb_druid_100` `ssb_druid_100` > GROUP BY 1.1001; > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-19674) Group by Decimal Constants push down to Druid tables.
[ https://issues.apache.org/jira/browse/HIVE-19674?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-19674: --- Status: Patch Available (was: Open) > Group by Decimal Constants push down to Druid tables. > - > > Key: HIVE-19674 > URL: https://issues.apache.org/jira/browse/HIVE-19674 > Project: Hive > Issue Type: Improvement > Components: Druid integration >Reporter: slim bouguerra >Assignee: Vineet Garg >Priority: Major > Attachments: HIVE-19674.1.patch, HIVE-19674.2.patch > > > Queries like following gets generated by Tableau. > {code} > SELECT SUM(`ssb_druid_100`.`lo_revenue`) AS `sum_lo_revenue_ok` > FROM `druid_ssb`.`ssb_druid_100` `ssb_druid_100` > GROUP BY 1.1001; > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-19674) Group by Decimal Constants push down to Druid tables.
[ https://issues.apache.org/jira/browse/HIVE-19674?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-19674: --- Attachment: HIVE-19674.2.patch > Group by Decimal Constants push down to Druid tables. > - > > Key: HIVE-19674 > URL: https://issues.apache.org/jira/browse/HIVE-19674 > Project: Hive > Issue Type: Improvement > Components: Druid integration >Reporter: slim bouguerra >Assignee: Vineet Garg >Priority: Major > Attachments: HIVE-19674.1.patch, HIVE-19674.2.patch > > > Queries like following gets generated by Tableau. > {code} > SELECT SUM(`ssb_druid_100`.`lo_revenue`) AS `sum_lo_revenue_ok` > FROM `druid_ssb`.`ssb_druid_100` `ssb_druid_100` > GROUP BY 1.1001; > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-19674) Group by Decimal Constants push down to Druid tables.
[ https://issues.apache.org/jira/browse/HIVE-19674?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-19674: --- Attachment: HIVE-19674.2.patch > Group by Decimal Constants push down to Druid tables. > - > > Key: HIVE-19674 > URL: https://issues.apache.org/jira/browse/HIVE-19674 > Project: Hive > Issue Type: Improvement > Components: Druid integration >Reporter: slim bouguerra >Assignee: Vineet Garg >Priority: Major > Attachments: HIVE-19674.1.patch > > > Queries like following gets generated by Tableau. > {code} > SELECT SUM(`ssb_druid_100`.`lo_revenue`) AS `sum_lo_revenue_ok` > FROM `druid_ssb`.`ssb_druid_100` `ssb_druid_100` > GROUP BY 1.1001; > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-19674) Group by Decimal Constants push down to Druid tables.
[ https://issues.apache.org/jira/browse/HIVE-19674?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-19674: --- Attachment: (was: HIVE-19674.2.patch) > Group by Decimal Constants push down to Druid tables. > - > > Key: HIVE-19674 > URL: https://issues.apache.org/jira/browse/HIVE-19674 > Project: Hive > Issue Type: Improvement > Components: Druid integration >Reporter: slim bouguerra >Assignee: Vineet Garg >Priority: Major > Attachments: HIVE-19674.1.patch > > > Queries like following gets generated by Tableau. > {code} > SELECT SUM(`ssb_druid_100`.`lo_revenue`) AS `sum_lo_revenue_ok` > FROM `druid_ssb`.`ssb_druid_100` `ssb_druid_100` > GROUP BY 1.1001; > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-19674) Group by Decimal Constants push down to Druid tables.
[ https://issues.apache.org/jira/browse/HIVE-19674?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-19674: --- Status: Open (was: Patch Available) > Group by Decimal Constants push down to Druid tables. > - > > Key: HIVE-19674 > URL: https://issues.apache.org/jira/browse/HIVE-19674 > Project: Hive > Issue Type: Improvement > Components: Druid integration >Reporter: slim bouguerra >Assignee: Vineet Garg >Priority: Major > Attachments: HIVE-19674.1.patch > > > Queries like following gets generated by Tableau. > {code} > SELECT SUM(`ssb_druid_100`.`lo_revenue`) AS `sum_lo_revenue_ok` > FROM `druid_ssb`.`ssb_druid_100` `ssb_druid_100` > GROUP BY 1.1001; > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-19674) Group by Decimal Constants push down to Druid tables.
[ https://issues.apache.org/jira/browse/HIVE-19674?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-19674: --- Status: Patch Available (was: Open) > Group by Decimal Constants push down to Druid tables. > - > > Key: HIVE-19674 > URL: https://issues.apache.org/jira/browse/HIVE-19674 > Project: Hive > Issue Type: Improvement > Components: Druid integration >Reporter: slim bouguerra >Assignee: Vineet Garg >Priority: Major > Attachments: HIVE-19674.1.patch > > > Queries like following gets generated by Tableau. > {code} > SELECT SUM(`ssb_druid_100`.`lo_revenue`) AS `sum_lo_revenue_ok` > FROM `druid_ssb`.`ssb_druid_100` `ssb_druid_100` > GROUP BY 1.1001; > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-19674) Group by Decimal Constants push down to Druid tables.
[ https://issues.apache.org/jira/browse/HIVE-19674?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-19674: --- Status: Open (was: Patch Available) > Group by Decimal Constants push down to Druid tables. > - > > Key: HIVE-19674 > URL: https://issues.apache.org/jira/browse/HIVE-19674 > Project: Hive > Issue Type: Improvement > Components: Druid integration >Reporter: slim bouguerra >Assignee: Vineet Garg >Priority: Major > Attachments: HIVE-19674.1.patch > > > Queries like following gets generated by Tableau. > {code} > SELECT SUM(`ssb_druid_100`.`lo_revenue`) AS `sum_lo_revenue_ok` > FROM `druid_ssb`.`ssb_druid_100` `ssb_druid_100` > GROUP BY 1.1001; > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-19674) Group by Decimal Constants push down to Druid tables.
[ https://issues.apache.org/jira/browse/HIVE-19674?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-19674: --- Status: Patch Available (was: Open) > Group by Decimal Constants push down to Druid tables. > - > > Key: HIVE-19674 > URL: https://issues.apache.org/jira/browse/HIVE-19674 > Project: Hive > Issue Type: Improvement > Components: Druid integration >Reporter: slim bouguerra >Assignee: Vineet Garg >Priority: Major > Attachments: HIVE-19674.1.patch > > > Queries like following gets generated by Tableau. > {code} > SELECT SUM(`ssb_druid_100`.`lo_revenue`) AS `sum_lo_revenue_ok` > FROM `druid_ssb`.`ssb_druid_100` `ssb_druid_100` > GROUP BY 1.1001; > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-19674) Group by Decimal Constants push down to Druid tables.
[ https://issues.apache.org/jira/browse/HIVE-19674?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-19674: --- Issue Type: Improvement (was: Bug) > Group by Decimal Constants push down to Druid tables. > - > > Key: HIVE-19674 > URL: https://issues.apache.org/jira/browse/HIVE-19674 > Project: Hive > Issue Type: Improvement > Components: Druid integration >Reporter: slim bouguerra >Assignee: Vineet Garg >Priority: Major > Attachments: HIVE-19674.1.patch > > > Queries like following gets generated by Tableau. > {code} > SELECT SUM(`ssb_druid_100`.`lo_revenue`) AS `sum_lo_revenue_ok` > FROM `druid_ssb`.`ssb_druid_100` `ssb_druid_100` > GROUP BY 1.1001; > {code} > The Group key is pushed down to Druid as a Constant Column, this leads to an > Exception while parsing back the results since Druid Input format does not > allow Decimals. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-19674) Group by Decimal Constants push down to Druid tables.
[ https://issues.apache.org/jira/browse/HIVE-19674?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-19674: --- Description: Queries like following gets generated by Tableau. {code} SELECT SUM(`ssb_druid_100`.`lo_revenue`) AS `sum_lo_revenue_ok` FROM `druid_ssb`.`ssb_druid_100` `ssb_druid_100` GROUP BY 1.1001; {code} was: Queries like following gets generated by Tableau. {code} SELECT SUM(`ssb_druid_100`.`lo_revenue`) AS `sum_lo_revenue_ok` FROM `druid_ssb`.`ssb_druid_100` `ssb_druid_100` GROUP BY 1.1001; {code} The Group key is pushed down to Druid as a Constant Column, this leads to an Exception while parsing back the results since Druid Input format does not allow Decimals. > Group by Decimal Constants push down to Druid tables. > - > > Key: HIVE-19674 > URL: https://issues.apache.org/jira/browse/HIVE-19674 > Project: Hive > Issue Type: Improvement > Components: Druid integration >Reporter: slim bouguerra >Assignee: Vineet Garg >Priority: Major > Attachments: HIVE-19674.1.patch > > > Queries like following gets generated by Tableau. > {code} > SELECT SUM(`ssb_druid_100`.`lo_revenue`) AS `sum_lo_revenue_ok` > FROM `druid_ssb`.`ssb_druid_100` `ssb_druid_100` > GROUP BY 1.1001; > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-19674) Group by Decimal Constants push down to Druid tables.
[ https://issues.apache.org/jira/browse/HIVE-19674?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Vineet Garg updated HIVE-19674: --- Attachment: HIVE-19674.1.patch > Group by Decimal Constants push down to Druid tables. > - > > Key: HIVE-19674 > URL: https://issues.apache.org/jira/browse/HIVE-19674 > Project: Hive > Issue Type: Bug > Components: Druid integration >Reporter: slim bouguerra >Assignee: Vineet Garg >Priority: Major > Attachments: HIVE-19674.1.patch > > > Queries like following gets generated by Tableau. > {code} > SELECT SUM(`ssb_druid_100`.`lo_revenue`) AS `sum_lo_revenue_ok` > FROM `druid_ssb`.`ssb_druid_100` `ssb_druid_100` > GROUP BY 1.1001; > {code} > The Group key is pushed down to Druid as a Constant Column, this leads to an > Exception while parsing back the results since Druid Input format does not > allow Decimals. -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Updated] (HIVE-19674) Group by Decimal Constants push down to Druid tables.
[ https://issues.apache.org/jira/browse/HIVE-19674?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] slim bouguerra updated HIVE-19674: -- Component/s: Druid integration > Group by Decimal Constants push down to Druid tables. > - > > Key: HIVE-19674 > URL: https://issues.apache.org/jira/browse/HIVE-19674 > Project: Hive > Issue Type: Bug > Components: Druid integration >Reporter: slim bouguerra >Assignee: slim bouguerra >Priority: Major > > Queries like following gets generated by Tableau. > {code} > SELECT SUM(`ssb_druid_100`.`lo_revenue`) AS `sum_lo_revenue_ok` > FROM `druid_ssb`.`ssb_druid_100` `ssb_druid_100` > GROUP BY 1.1001; > {code} > The Group key is pushed down to Druid as a Constant Column, this leads to an > Exception while parsing back the results since Druid Input format does not > allow Decimals. -- This message was sent by Atlassian JIRA (v7.6.3#76005)