Hi I am pretty sure I am doing something wrong with my json schema, my usecase is that I add some elements to a table using documents and in this case the elements are added through name, value key pair.…
I have a csv file that with rows that looks like this: 745198;2024-09-10 10:09:10.7;leaf-2;{"Accelerometer": {"X": 0.055297852, "Y": 0.993530273, "Z": 0.000244141}} 745199;2024-09-10 10:09:10.71;leaf-2;{"Accelerometer": {"X": 0.056274414, "Y": 0.994384766, "Z": 0.000976563}} 745200;2024-09-10 10:09:10.721;leaf-2;{"Accelerometer": {"X": 0.055786133, "Y": 0.994018555, "Z": 0.000854492}} 745201;2024-09-10 10:09:10.732;leaf-2;{"Accelerometer": {"X": 0.055053711,…
Today I have a challenge at my school, it is convert a CSV file to a JSON file. This CSV has a table structure (which means contains the information from an oracle table in this example). So i have to…
I have a SQL Server database table with this structure: CREATE TABLE json_file_table ( file_id VARCHAR(50) PRIMARY KEY, json_value VARBINARY(MAX) ); How to write a SQL query to insert value into the database and bind values to that query in…
I'm almost at the end of a thing I like to make for my website. I have a json file that I use as a sort of database for my thumbails for the recipes... The most info displays as I…
i have been trying for hours but with no luck, I want to extract the (id, remote_ip, listen_addr) and put it in a txt file I have managed to do so with curl -s https://pastebin.com/raw/gGt524CS | grep -e "id" -e…
I have a .csv log file containing three json lines for each client. For example: {"name":"John","phone":"08847","politic":"on","ville":"LA","isTest":"false","source":"t3_1"} {"data":{"name":"John","phone":"+8847","city":"LA","source":"t3_1","cameF":"a1"},"token":"bd67a","isTest":false} {"data":{"responseId":"R_2hs","city":"LA","cameF":"cpl_agency2","source":"t3_1"},"success":true,"ts":1721394844,"message":null} I don't understand how you can combine three separate lines into one and then read the json. Starting reading the file: import…
I am working on a Node.js backend project using Socket.IO and am facing two issues when trying to interact with the Socket.IO endpoints via Postman: 1. Connection and Event Emission Issue on Different URLs: I am able to connect and…
I am working with a large gzipped JSON file containing review data, formatted as a list of JSON objects. Each object is separated by a newline character. My goal is to efficiently extract the review_text field from each object using…
I have this data in a json column #mycolumn { "key": "KEY", "elements": [ { "name": "NAME_1" }, { "name": "NAME_2" } { "name": "NAME_3" } ] } I want to select all the elements[*].name. I have tried: select JSON_EXTRACT_PATH_TEXT(mycolumn,…