ALL COVERED TOPICS

NoSQL Benchmarks NoSQL use cases NoSQL Videos NoSQL Hybrid Solutions NoSQL Presentations Big Data Hadoop MapReduce Pig Hive Flume Oozie Sqoop HDFS ZooKeeper Cascading Cascalog BigTable Cassandra HBase Hypertable Couchbase CouchDB MongoDB OrientDB RavenDB Jackrabbit Terrastore Amazon DynamoDB Redis Riak Project Voldemort Tokyo Cabinet Kyoto Cabinet memcached Amazon SimpleDB Datomic MemcacheDB M/DB GT.M Amazon Dynamo Dynomite Mnesia Yahoo! PNUTS/Sherpa Neo4j InfoGrid Sones GraphDB InfiniteGraph AllegroGraph MarkLogic Clustrix CouchDB Case Studies MongoDB Case Studies NoSQL at Adobe NoSQL at Facebook NoSQL at Twitter

NAVIGATE MAIN CATEGORIES

Close

Unix: All content tagged as Unix in NoSQL databases and polyglot persistence

Implementing SQL With Unix Utilities

  1. SELECT col1, col2 (i.e. projections) can be implemented with several variants of Unix utilities: cut and awk are the two most obvious. 2. JOIN can be implemented with the… wait for it join utility. You’ll need to sort its input first, though.
  2. Many GROUP BY operations can be performed with combinations of grep -c, sort with or without the -urnk options (look at the man page — you can apply options to individual sort keys), and uniq with or without the -c option. Many more can be done with 20 or 30 characters of awk.
  3. Output formatting is easy with column, especially with the -t option.

Reminded me of the now vanished from the Internet Ted Dziuba’s Taco Bell Programming.

Original title and link: Implementing SQL With Unix Utilities (NoSQL database©myNoSQL)

via: http://www.xaprb.com/blog/2012/10/12/implementing-sql-with-unix-utilities/