0

Tablename:-table_data_set_attr, Columnname:-value. I have structured data and json data in the same column as below:

data format in 1st row: https://al/mic/nap_6101

dataformat in 2nd row

[{'file_name': 'QPRACE2.SSTD.KRATOA.AP6101_%Y%m%d', 'input_format': 'fixed', 'output_format': 'parquet', 'delimiter': 'None', 'extension': '.dat', 'header': 0, 'footer': 0, 'date_pattern': '%Y%m%d%H%M%S', 'type': 'incremental'}]

How to extract the structured data from the first row(https://al/mic/nap_6101) and QPRACE2.SSTD.KRATOA.AP6101_%Y%m%d from the array. Tried below query, but not returning data.

select value -> 0 ->> 'file_name' as filename 
from table_data_set_attr;
Improve this question
2
  • It's the same solution as your previous question: stackoverflow.com/questions/62014327 Commented Jun 2, 2020 at 7:16
  • The data is coming in single quotes. I believe that is the problem. Is that correct. Commented Jun 2, 2020 at 21:58
Related questions
1
Select from JSON array in Postgres
44
How to get elements from Json array in PostgreSQL
11
How to extract json array elements in postgresql
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.