-h 
        The hostname to the server connect to. Default: 127.0.0.1

-p 
        The port number of the server to connect to. Default: 3000
 
-U 
        User name used to authenticate with cluster. Default: none
 
 
-P[]
        Password used to authenticate with cluster. Default: none
 
        User will be prompted on command line if -P specified and no password is given.

-h 服务器ip，默认为：127.0.0.1
-p 端口号。默认为：3000
-c 执行指定的命令
-f 执行的命令在指定的文件中
-v启用详细输出
-e打开命令的反馈模式  

aql -c 'show namespaces'
aql -c 'show sets;show namespaces'

show namespaces

show sets

显示test下的所有索引
show indexes test

创建索引 索引存储的类型 NUMERIC or STRING
create testindex on test.testset(binx) numeric

删除索引 
drop index test testindex

正在运行的查询
show queries

正在运行的扫描
show scans


namespace.dataset
     
INSERT INTO ns1.test (PK,id,name) VALUES ('1',1,'cat')

INSERT INTO ns1.test (PK,id,name) VALUES ('2',2,'dog')

select * from   ns1.test
+----+-------+
| id | name  |
+----+-------+
| 1  | "cat" |
| 2  | "dog" |
+----+-------+
2 rows in set (1.755 secs)


        
MANAGE UDFS


REGISTER MODULE '~/test.lua'
SHOW MODULES
DESC MODULE test.lua
REMOVE MODULE test.lua




SELECT * FROM ns1.data_clean WHERE PK = 'a'
 


STAT NAMESPACE ns1
STAT SYSTEM

Secondary Index Statistics
STAT INDEX  




aerospike工具集aql
https://blog.csdn.net/songhuiqiao/article/details/50262647

https://www.cnblogs.com/xiaoit/p/4552648.html