[
https://issues.apache.org/jira/browse/HIVE-13647?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16434992#comment-16434992
]
靳峥 commented on HIVE-13647:
---------------------------
In fact, the field names of struct is insensitive in case.
I suppose it's better to store struct field names in lower case into metastore.
> named_struct changes the column name to lowercase
> -------------------------------------------------
>
> Key: HIVE-13647
> URL: https://issues.apache.org/jira/browse/HIVE-13647
> Project: Hive
> Issue Type: Bug
> Affects Versions: 0.14.0
> Reporter: Sivashankar
> Assignee: Sivashankar
> Priority: Minor
>
> the named_struct is changing the column name "dropOffLocation" and
> "pickUpLocation" to lower case as dropofflocation and pickuplocation
> respectively
> named_struct(
> 'notes',notes,
> 'dropOffLocation',dropOffLocation,
> 'pickUpLocation',pickUpLocation,
> 'email',email,
> 'phone',phone,
> 'username',username,
> 'lastname',lastname,
> 'firstname',firstname,
> 'loc',loc
> )as chng_hist_d
> from(
> change_history.d.notes as notes,
> change_history.d.dropOffLocation as dropOffLocation,
> change_history.d.pickUpLocation as pickUpLocation,
> change_history.d.email as email,
> change_history.d.phone as phone,
> change_history.d.username as username,
> change_history.d.lastName as lastname,
> change_history.d.firstName as firstname,
> change_history.d.loc as loc
> from --TABLENAME-- LATERAL VIEW explode(changehistory) exploded_table as
> change)a)b;
> result came as
> 2.906Zi","notes":null,"dropofflocation":null,"pickuplocation":null,"email":null,"phone":null,"username":null,
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
