Any way return csv or at lest plain text from the AQL?

Feature Discussion Query & Indexing
,
1

Hi

How can I ask aql do not format output from the query and return it as plain text? I have function which returns tsv, but aql formats it as table or json. How to disable it?

Here is an example

+---------------------+
| remap               |
+---------------------+
| "user2        td:td_user2" |
| "user1        td:td_user1" |
+---------------------+

but I want

 "user2        td:td_user2" 
 "user1        td:td_user1"

Any way how to achieve that?

Thanks

2

AQL supports a few output modes, JSON is probably the closest option.

aql> set output json
3

Any plan to add more options, in particular plain text?

4

Try aql> set output raw

5 
aql> set output raw
Unsupported command format with token -  'raw'

Since what version it’s available? I use Aerospike Community Edition build 3.13.0.11. Unfortunately, I cannot upgrade to newest version.

6

AQL should be backward compatible - you can grab the latest version from our packages. In the near future, the AQL project should receive a public repo.