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-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org

Reply via email to