By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

Glue data quality; Parsing error

0

Hi, I'm implementing a case where either one column can be null, but not both in the same record. And implementing rule (ColumnValues "col_1" = NULL) or (ColumnValues "col_2" = NULL) I'm seeing below error Parsing Error: line x:xx no viable alternative at input '(ColumnValues "session_id" = NULL'

Topics
Analytics
Tags
AWS Glue
Language
English
rePost-User-2068751
asked 12 days ago43 views
1 Answer
0

Addition to issue above; seems like the issue is with using NULL in the ruleset. As I'm getting same error while implementing """ColumnValues "col_name" = NULL""". Same use case is mentioned in AWS Docs, weird it's throwing error. (https://docs.aws.amazon.com/glue/latest/dg/dqdl.html#dqdl-keywords-null-empty-whitespaces_only)

rePost-User-2068751
answered 10 days ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content