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