News for hackers. Stuff that matters.

A comment on Modern Data Practice and the SQL Tradition. Parent comment

Re:Modern Data Practice and the SQL Tradition by nomel on Friday November 08, 2019 @12:33PM (#21484560)
> SQL to dump data

Is this another way to say you use SQL to query specific data from a larger dataset?

[ Parent | on HN ]
Re:Modern Data Practice and the SQL Tradition by chrisjc on Friday November 08, 2019 @01:33PM (#21485241)
I imagine they mean SQL to unload from whatever SQL storage engine out to blob(s3,azure,etc), HDFS or local-file system.

COPY INTO s3://mybucket/foobar/ from (select a, b, c from ...);

[ Parent | on HN ]
Re:Modern Data Practice and the SQL Tradition by gigatexal on Friday November 08, 2019 @01:28PM (#21485190)
Yeah sorry. I used the cli front end to my database from a container and had it dump the results to a file that I then massaged with python
[ Parent | on HN ]