Hacker News Reader

Apache Pig and Hive are other systems that can do this, minus the one file limitation.

json_fdw to Citus DB or any other PostgreSQL based distributed database, is like json serde to Hive.

So, I think you should probably compare the json_fdw to json serde, and Citus DB to Hive.