Details
-
Bug
-
Status: Open
-
Minor
-
Resolution: Unresolved
-
0.14.0
-
None
-
None
-
None
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,