Command line querying


#1

cli has been deprecated in Aerospike 3.9. I am using aql to query records but aql doesnt return the complete data for big bins. It will truncate the data returned. Is it possible for it to truly dump the whole record? If not, is it possible to use the deprecated cli?


#2

How big is the bin data? You might want to also try the following settings - valid only for the current aql session.

aql> set output json
aql> set record_print_metadata true

aql> select * from test.demo where PK="testKey2"
[
  {
    "digest": "AAAAAAAAAAAAAAAAAAAAAAAAAAA=",
    "ttl": 10906,
    "gen": 5,
    "bins": {
      "test-bin-1": 1234,
      "test-bin-2": "test-bin-2-data"
    }
  }
]

Caveat: AQL bug - any output with where clause shows incorrect digest value.


#3

Thanks, but that doesnt work for me. The record is at max record size (which is why I want to dump the record).

Setting output as json actually returns empty data for bin. I dont care about metadata, but want to do dump the entire record.


#4

OK. You could probably quickly roll your own custom tool. If you install the C client, there is an examples subdirectoy which has basic put / get etc. You could also look at trimmed down version I have for put and modify for get at: https://github.com/pygupta/aerospike-discuss/tree/master/topic3717 Look at example.c and Makefile, add some command line options and roll your own tool?