CREATE view USING json and *include* _metadata, _rescued_data
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-18-2024 09:06 AM
Title may be self-explanatory. Basically, I'm curious to ask if it's possible (and if so how) to add `_metadata` and `_rescued_data` fields to a view "using json".
e.g.
%sql
CREATE OR REPLACE VIEW entity_view
USING json
OPTIONS (path="/.../.*json",multiline=true)
Below I show it's possible to do this with `read_files` in Spark SQL:
Below I show an error trying to query these fields.. not sure if I'm doing something wrong: