All Questions
5,083
questions
-1
votes
0
answers
7
views
Using T-SQL for extracting from JSON
I am trying to extract data from the following json and pivot the data in "rows" to columns.
{
"tables": [
{
"name": "PrimaryResult",
"...
- 143
1
vote
1
answer
28
views
Accessing deeply nested fields using DuckDB SQL
I have some deeply nested data from a json file and I'm trying to load it into DuckDB:
"events": [
{
"id": "401638586",
"uid": "s:40~l:41~...
- 8,361
0
votes
2
answers
28
views
Oralce JSON_TRANSFORM, set/insert/append not working
Why this:
with j(jval) AS
(
select JSON_SERIALIZE('{"contract" :{"contract-type" : "P",
"contract-id" : 123451,
"proposal-no" : "123456&...
- 652
0
votes
1
answer
32
views
Querying Json_Object_t using dot notation in Oracle 19c
I have a case where Json document is passed as CLOB input to a stored procedure.
I am converting it into Json Object as below
l_js_obj := JSON_OBJECT_T(p_js_clob_i);
Json:
{"Key1":{"...
- 153
-1
votes
0
answers
66
views
How to create a table from a JSON recordset in Firebird DB? [closed]
I am documenting how to create a table from a JSON recordset in multiple databases. So far I have figured out MySQL, SAP HANA, Oracle, Postgres, SQL Server, Snowflake, and SQLite. How would I do ...
- 889
1
vote
2
answers
50
views
JSON_TABLE()-Function in Oracle's SQL
I'm currently struggling to import my API-Response to my Oracle table.
I'm using the JSON_TABLE() but this function is not working as expected.
I have a JSON value like this:
{
"CAR-1": [
...
- 23
0
votes
3
answers
57
views
AWS Redshift SQL - How to check if a Json object has values in it?
1/ I am using SQL on AWS and trying to detect quickly when a Json object has key-value in it. Anyone knows it? Thanks
For example:
A. {"context":{"abc":"123"} --> Yes
...
- 31
0
votes
0
answers
47
views
Return the latest group of records inserted by specifically me into a table along with their ID in the table?
I have a table of Customers, named Customer with the following columns:
CustomerID
CustomerName
ContactNo
Address
DateCreated
1
Idola Steenson
438614198
Morena
2022-08-14 09:48:00
2
Graham Buckner
...
0
votes
1
answer
38
views
Oracle SQL JSON_TABLE PATH references in some columns returning next record (+1?) child data elements
I am working for the first time with .JSON data stored in a Oracle DB (BLOB) column, and an having issues with getting my SQL query to render data as desired. This is also my first time using ...
- 3,904
0
votes
0
answers
61
views
How can I bring in the JSON string as a variable in a PySpark function?
The goal is to call a filter function from JSON as a string from an Excel document. The JSON will be updated in an Excel report and the goal is to pull in the filter and then makes sure the filter ...
0
votes
1
answer
27
views
parse json formatted string in Impala
I have a table with multiple columns, one of which is a json formatted string. Sample data is shown below. The name of the column is json_data
{"A":{"B":"b","C"...
- 103
0
votes
1
answer
61
views
Importing JSON file into SQL Server
I am not familiar with importing JSON files. I received the code below to import a JSON file but I do not know where to find the data once it is imported? Can someone tell me where the file would be ...
- 11
0
votes
1
answer
51
views
Generate Nested JSON payload using JSON function Oracle 19c
Hi I created a query to generate JSON but I am getting ORA-00935: group function is nested too deeply. I am using Oracle 19c.
Below is the query I wrote but my grouping is somehow repeating.When I use ...
- 943
0
votes
1
answer
31
views
How do I use JSON functions on a generated column?
My schema:
CREATE TABLE my_table (
id INTEGER PRIMARY KEY,
json_data TEXT
);
The json_data column is of the format:
[
{"key": "foo", "date": "2023-01-01&...
- 50.2k
2
votes
2
answers
92
views
postgres - How to parse json array elements?
PostgreSQL 15.4
Below is the postgres table table1:
CREATE TABLE table1 (
id INT PRIMARY KEY,
name TEXT,
skills JSON
);
with below rows inserted:
INSERT INTO table1 (id, name, skills) VALUES
(1, '...
