NickYoungPeng commented on issue #4809: URL: https://github.com/apache/seatunnel/issues/4809#issuecomment-1558685677
> ``` > > > Can you provide details of the creation statement and test data? > > > > create table db_test_dev.test3 ( name string, age int, emails array, phones map<string,string>, org structcode:string,name:string,tel:string ) > > > > lisi,12,"[""[[email protected]](mailto:[email protected])"",""[[email protected]](mailto:[email protected])"",""[[email protected]](mailto:[email protected])""]","{""home"":""13987167117"",""office"":""15178968888""}","{""code"":""110000"",""name"":""中国银行北京分公司"",""tel"":""010-86678888""}" lisi,12,"[""[[email protected]](mailto:[email protected])"",""[[email protected]](mailto:[email protected])"",""[[email protected]](mailto:[email protected])""]","{""home"":""13987167117"",""office"":""15178968888""}","{""code"":""110000"",""name"":""中国银行北京分公司"",""tel"":""010-86678888""}" > ``` > > Can you convert to insert statement It looks so messy / INSERT INTO db_test_dev.test3 select 'lisi', 12, array("[email protected]", "[email protected]", "[email protected]") , map("home", "13987167117", "office", "15178968888"), named_struct('code', '110000', 'name', '中国银行北京分公司', 'tel', '010-86678888') from dummy_TBL limit 1; -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
