All Questions
5,081
questions
1
vote
1
answer
33
views
How to count values from a column with JSON content?
I have a table with singers and each singer can be linked to many musical styles.
Musical Styles are in a TEXT column, but the content of the column has JSON format.
I want to count the number of ...
- 101
-1
votes
0
answers
54
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
-3
votes
1
answer
30
views
How to display a one-to-many relationship in a column in JSON format
Table points has columns
point_id (int unsigned, auto_increment, primary key)
name (varchar(512))
Table filters has columns
filter_id (int unsigned, auto_increment, primary key)
label (varchar(128))...
- 1
1
vote
2
answers
41
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
55
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
32
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
54
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
18
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
60
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
50
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
89
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, '...
0
votes
1
answer
97
views
Azure Mapping JSON - convert empty string or whitespace cells from CSV's to null
I'm importing multiple addressbase CSV files that don't have headers via Azure Synapse and ADLS so using MAPPING_JSON in an ETL.Process table with SQL Server Management Studio 20.1.10.0.
That part is ...
1
vote
1
answer
70
views
JSON_EQUAL in PL/SQL
How can I compare two JSON_OBJECT_T?
I have a PL/SQL procedure. I am getting a return of an array of JSON OBJECT from the GET request from HTTP API endpoint. I have prepared a JSON_OBJECT_T record ...
- 11