Quick Tip: Query InfiniDB on a Linux LAN/WAN

InfiniDB is a proprietary SQL-like DB. You can query it much like a MySQL DB on a Bash command line:

 

mysql -q -r -h 10.00.0.0-u root hsa_infinidb -e “SQL QUERY GOES HERE” >outfile.tsv
where db represents whatever your InfiniDB server is named an 10.00.0.0 represents the LAN/WAN IP address of your server/cluster.
An outfile is optional, but usually better than having your results print to the screen.