You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Lijia Liu (JIRA)" <ji...@apache.org> on 2017/09/28 10:19:00 UTC

[jira] [Created] (SPARK-22155) Generates a simple default alias for the function in select

Lijia Liu created SPARK-22155:
---------------------------------

             Summary: Generates a simple default alias for the function in select
                 Key: SPARK-22155
                 URL: https://issues.apache.org/jira/browse/SPARK-22155
             Project: Spark
          Issue Type: Bug
          Components: SQL
    Affects Versions: 2.2.0
            Reporter: Lijia Liu
            Priority: Minor


When execute some query witch has function in select clause,  Spark use Pretty SQL as default alias.
But, Consider the following case:

{code:java}
create table tmp1
As 
Select func(a, b)
From tb1;

create table tmp2
As 
Select func(a, b)
From tb2;

Insert overwrite table tb3
select *
From 
tb1 a
Union
Tb2 b;
{code}

Create table will fail due to func(a, b) has comma. Therefore, we can use simple alias refer to hive.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org