Comments (2)
You're right, it is probably easier to do this (when using column names in first row):
-oraw -ih "SELECT json_object('id', u.id, 'name', u.name, 'dates',json_group_array(h.date)) FROM ./user.csv AS u LEFT JOIN ./hist.csv as h ON (u.id=h.id) GROUP BY u.id"
which results in
{"id":"1","name":"userA","dates":["2017-7-10"]}
{"id":"2","name":"userB","dates":["2017-7-10","2017-7-11"]}
from trdsql.
Thank you for a good suggestion.
But for now, I have no idea how to implement it.
I'm thinking about using SQL JSON functions to combine nested outputs.
from trdsql.
Related Issues (20)
- Support shell text utilities for string functions HOT 2
- Standard Deviation HOT 3
- Want to get Integer values from JSON data instead of exponential notation HOT 1
- UTF-8 Byte Order Markers should be ignored HOT 1
- -driver postgres returns SSL error HOT 2
- Not able to use JSON_EXTRACT HOT 2
- Can't you use the WHERE statement? HOT 5
- build Dockerfile with multi-stage ? It also supports ARM64 HOT 2
- `CREATE TABLE AS` and` INSERT INTO table SELECT` Is output as an example of SQL
- Question. Can trdsql query by a column has no value(null or empty) HOT 5
- binary is not completely statically compiled HOT 5
- "null" representation HOT 1
- Specifying column types HOT 3
- Multiple queries HOT 2
- Support for DuckDB HOT 1
- `-ijq` does not work correctly from stdin HOT 1
- Error: Cannot tap noborus/tap: invalid syntax in tap! HOT 1
- Cannot use the tool, process gets instantly killed with 137 exit code HOT 13
- support logfmt
- feature request: support input format yaml file HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from trdsql.