我在JSON Extractor中的JSON路径表达式是

CREATE TABLE top200k (Id STRING,Score STRING,ViewCount STRING,Body STRING,OwnerUserId STRING,Title STRING,Tags STRING,AnswerCount INT,CommentCount INT,FavoriteCount INT) ROW FORMAT DELIMITED FIELDS TERMINATED BY "    " LOCATION "hdfs://localhost:9000/abc/xyz/"

如果此表达式未返回任何结果，我想将$.data.Transactions.[?(@.transactionId=='${transId}')].status 分配给变量