0

We have an Apache Beam 2.4.0 pipeline that runs BeamSql queries. In BeamSql the SQL statement 'LIKE' throws an exception 'LIKE is not implemented yet'. Is there a work around for 'LIKE' in BeamSql? We need to be able to perform wildcard queries on strings.

Rui Wang
  • 789
  • 6
  • 11
Anna Kasikova
  • 37
  • 1
  • 4

1 Answers1

2

One workaround is to define a UDF that implements the logic.

I have filed BEAM-4385 to track implementation of LIKE.

A more complete set of operators will be supported when BEAM-2281 is addressed.

Kenn Knowles
  • 5,838
  • 18
  • 22
  • 2
    to add to Kenn's answer, link to the guide about UDFs: https://beam.apache.org/documentation/dsls/sql/user-defined-functions/ – Anton May 23 '18 at 03:27