You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "t oo (JIRA)" <ji...@apache.org> on 2018/12/13 02:07:00 UTC

[jira] [Created] (SPARK-26354) Ability to return schema prefix before dataframe column names

t oo created SPARK-26354:
----------------------------

             Summary: Ability to return schema prefix before dataframe column names
                 Key: SPARK-26354
                 URL: https://issues.apache.org/jira/browse/SPARK-26354
             Project: Spark
          Issue Type: New Feature
          Components: SQL
    Affects Versions: 2.4.0
            Reporter: t oo


This query returns dataframe with prdct, prdct, addr, pho :

select a.prdct, b.prdct, a.addr, b.pho from ac a

full outer join baa b on a.prdct = b.prdct

 

This feature Jira is about having a new config flag (defaulted to false) that would be show.schema.prefix. When true it should return dataframe for above example of a.prdct, b.prdct, a.addr, b.pho. This would help to clearly distinguish origin of the columns with same name in >=2 tables without having to rewrite query to put specific alias ie as a_prdct or as b_prdct. My current use case is loading dataframe into List of Maps in java but it is only taking the first prdct column rather than both prdct columns

 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

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