Posts Tagged ‘infinidb’

Quick-Tip: How to Populate a Table in InfiniDB in 1 Line

cat data.tsv |sudo /usr/local/Calpont/bin/cpimport -s ‘\t’ hsa_infinidb tablename

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.