hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sivashankar (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-13647) named_struct changes the column name to lowercase
Date Fri, 29 Apr 2016 09:10:12 GMT

     [ https://issues.apache.org/jira/browse/HIVE-13647?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Sivashankar updated HIVE-13647:
-------------------------------
       Priority: Minor  (was: Trivial)
    Description: 
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,



        Summary: named_struct changes the column name to lowercase  (was: named_struct changes
the column to lowercase)

> 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
(v6.3.4#6332)

Mime
View raw message