Apache Drillに感動した(２つのJSONファイルをSQLでJOINしてみた) - Qiita0: jdbc:drill:zk=local> SELECT test1.*, test2.point FROM . . . . . . . . . . . > dfs.`/opt/drill/test1.json` test1 . . . . . . . . . . . > JOIN dfs.`/opt/drill/test2.json` test2 ON (test1.id = test2.id); +------------+------------+------------+ | id | name | point | +------------+------------+------------+ | 1 | foo | 100 | | 2 | bar | 200 | +------------+------------+------------+ 2 rows selected
GitHub - harelba/q: q - Run SQL directly on delimited files and multi-file sqlite databases
GitHub - dinedal/textql: Execute SQL against structured text like CSV or TSV
