You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Krisztian Kasa (Jira)" <ji...@apache.org> on 2020/07/21 09:25:00 UTC
[jira] [Assigned] (HIVE-23750) Rewrite plan to join back tables:
support function calls in project
[ https://issues.apache.org/jira/browse/HIVE-23750?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Krisztian Kasa reassigned HIVE-23750:
-------------------------------------
Assignee: Krisztian Kasa
> Rewrite plan to join back tables: support function calls in project
> -------------------------------------------------------------------
>
> Key: HIVE-23750
> URL: https://issues.apache.org/jira/browse/HIVE-23750
> Project: Hive
> Issue Type: Improvement
> Reporter: Krisztian Kasa
> Assignee: Krisztian Kasa
> Priority: Major
> Labels: pull-request-available
> Time Spent: 10m
> Remaining Estimate: 0h
>
> {code}
> select
> c_first_name || ' ' || c_last_name,
> (ss_quantity * ss_list_price) * (1.0 - c_discount),
> c_customer_sk,
> ss_customer_sk
> from store_sales ss
> join customer c on ss_customer_sk = c_customer_sk;
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)