New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Creating 1NF table structure from json data #10

Open

anki-code opened this issue May 10, 2020 · 0 comments

Owner

anki-code commented May 10, 2020 •

edited

Loading

Input test.json file:

[
 {"a":{ "c":1, "d": [{"e":1}, {"e:2"}] } }
]

LSQL:

lsql> SELECT * FROM test_json
a.c   a.d
1     [{"e":1}, {"e:2"}]

lsql> SELECT * FROM test_json_a_d
a.c  a.d.e
1    1
1    2

For community:
⬇️ Please click the 👍 reaction instead of leaving a +1 or 👍 comment

The text was updated successfully, but these errors were encountered:

anki-code changed the title ~~Creating 1NF table structure from json data.~~ Creating 1NF table structure from json data

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment