topic Re: SQL Issues with 10.0 runtime in Data Engineering

SQL Issues with 10.0 runtime

yadsmc — Sun, 31 Oct 2021 07:40:12 GMT

I was testing my sqls with new 10.0 runtime and found some interesting/weird thing. The same sql with explode function fails for some scenarios in 10.0! Could not figure out yet the reason

Re: SQL Issues with 10.0 runtime

yadsmc — Sun, 31 Oct 2021 18:08:43 GMT

Update:

After some trail and errors, found that pos_explode works better in these scenarios. I feel like there is some parsing issue. Not sure though

Re: SQL Issues with 10.0 runtime

Anonymous — Mon, 01 Nov 2021 17:28:33 GMT

Hello, @Yadhuram MC. My name is Piper and I'm a community moderator for Databricks. It's nice to meet you and thank you for your question. Let us see what the community has to say, otherwise, we will get back.

Re: SQL Issues with 10.0 runtime

BilalAslamDbrx — Fri, 12 Nov 2021 12:05:03 GMT

@Yadhuram MC if the issue persists, please email me at bilal dot aslam at databricks dot com. I would like to get to the root of this issue. It