Hi Team, how can bring the address1.type and addrs...
# generaln
Nikhil Thomas
11/17/2023, 6:53 AMHi Team, how can bring the address1.type and addrss2.type to address_type in pinot table. So will be having 2 record .
Nikhil Thomas
11/17/2023, 6:53 AMAny help
Nikhil Thomas
11/17/2023, 7:40 AM@Mayank - any thought on this .
x
Xiang Fu
11/17/2023, 3:35 PM
i think what you can do is:
select address1.type as address type
UNION ALL
select address2.type as address_type
Xiang Fu
11/17/2023, 3:36 PM
If you want to have address_type in Pinot column, then you need to have a separate spark sql job to run this query
n
Nikhil Thomas
11/17/2023, 3:36 PMI needed that during ingestion and wanted only column in my table as adress type
x
Xiang Fu
11/17/2023, 3:36 PM
Then you need to have a flink or spark job for data preprocessing