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: [email protected]
For additional commands, e-mail: [email protected]
