nosingh
New Contributor
Joined 7 years ago
User Profile
User Widgets
Contributions
Double Quotes Parsing Error Expression
I am getting the below error when I am using the expression to run using the filter. If I remove them and run it, it works fine. The double quotes are causing issues. Any help would be greatly appreciated? I have changed the filed names because of confidentiality issues. Thank You ERROR: Expression parsing failed near – amap,'" >> { << ‘, ‘{’),’ (Reason: Mismatched input ‘{’ at line 9:60. Expecting one of: {, ‘||’, ‘&&’, ‘^’, ‘==’, ‘!=’, ‘>’, ‘<’, ‘>=’, ‘<=’, ‘+’, ‘-’, ‘*’, ‘/’, ‘%’, ‘?’, ‘instanceof’, ‘in’, ‘matches’, ‘[’, ‘(’, ‘.’, PropertyRef}; Resolution: Please check expression syntax) SQL: “REPLACE INTO abc.stg_order select DISTINCT 1 as orderno , 1 as orderId , 1 as subOrderId, 1 as itemId, case when pi.amap is null then JSON_EXTRACT_STRING(REPLACE(REPLACE(REPLACE(pi.amap,'”{‘, ‘{’),’}“‘,’}‘),’\”‘,’“‘),‘country’) else REPLACE(pi.amap::country, ‘"’, ‘’) end as country , case when pi.amap is null then JSON_EXTRACT_STRING(REPLACE(REPLACE(REPLACE(pi.att ,’”{‘, ‘{’),’}“‘, ‘}’),’\”‘, ‘"’) ,‘ff’) else REPLACE(pi.amap::ff, ‘"’, ‘’) end as ff , case when pi.amap is null then JSON_EXTRACT_STRING(REPLACE(REPLACE(REPLACE(pi.att ,’“{‘, ‘{’),’}”‘, ‘}’),’\“', '”‘) ,‘frame’) else REPLACE(pi.amap::frame, ‘"’, ‘’) end as frame , case when pi.amap is null then JSON_EXTRACT_STRING(REPLACE(REPLACE(REPLACE(pi.att,’“{‘, ‘{’),’}”‘, ‘}’),’\“', '”‘) ,‘orientation’) else REPLACE(pi.amap::orientation, ‘"’, ‘’) end as orientation , case when pi.amap is null then JSON_EXTRACT_STRING(REPLACE(REPLACE(REPLACE(pi.att,’" {‘, ‘{’),’}“‘, ‘}’),’\”‘, ‘"’) ,‘side’) else REPLACE(pi.amap::side, ‘"’, ‘’) end as side , case when pi.amap is null then REPLACE(REPLACE(REPLACE(pi.att ,’“{‘, ‘{’),’}”‘, ‘}’),’\“‘,’”') else pi.amap end as amap ,ci.componentId , pi.ingest_ts from abc.product pi JOIN abc.component ci on pi.Id = ci.Id WHERE pi.ingest_ts > ‘“+_filter_1+”’"2.4KViews0likes1CommentHow to get only 'X' number of columns from 'Y' number of columns using FileReader Snap?
My source files are in sftp location and I use FileReader snap to retrieve the data from that location. However, I need only specific columns from those files. FileReader reads all the columns and CSV parser generates all the data in that file. Those specific columns are already in the database. How to compare and write the data to the database? Thanks1.8KViews0likes0CommentsSFTP File Read from client source
Howdy All! I am trying to read SFTP files using the Directory browser snap. Can someone guide me what should be filled out in the filefilter tab. I don’t have anything to filter. Files are in .csv format If that snap is incorrect, what should be the correct snap. Thanks2.3KViews0likes1Comment