0

I have following code which I wrote in dremio.

Could you please tell me what is the meaning of this syntax? I tried to find, but I couldn't. I followed the tutorial in dremio, but I need to know what are the other sql functions we can use in dremio, specially for string and regular expressions? Also what are the other functions we can use in dremio as sql or else?

Here shop_names are in a list

01_bike,02_car,03_car,125_01,112_03,113_moto,112_678

select id, regexp_split(shop_names, '\Q,\E', 'ALL', 10) as new_shopes_names 
from table1
Gordon Linoff
  • 1,242,037
  • 58
  • 646
  • 786
user
  • 145
  • 1
  • 2
  • 12
  • I can only guess it means spit on comma (,) but the \Q and \E isn't something I recognize from other regular expression implementations. – Joakim Danielson May 13 '19 at 11:58
  • A Google search for `Dremio help functions` takes you to their documentation to answer the questions you have posed. – Sam M May 13 '19 at 15:21

0 Answers0