[
https://issues.apache.org/jira/browse/SPARK-26354?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16719831#comment-16719831
]
tooptoop4 commented on SPARK-26354:
-----------------------------------
there are many existing (and regularly run) queries written without alias, dont
want to be too strict with users
> 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
> Priority: Major
>
> 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]
