hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From 靳峥 (JIRA) <j...@apache.org>
Subject [jira] [Commented] (HIVE-13647) named_struct changes the column name to lowercase
Date Thu, 12 Apr 2018 06:15:00 GMT

    [ 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)

Mime
View raw message