관리 메뉴

ITGeine

AQL Query 본문

기타/메모

AQL Query

Nick9 2020. 6. 22. 10:36

terminal > ssh [계정명]@[ip명]

> aql

 

SHOW

show namespace

show sets

show bins

 

 

QUERY

SELECT <bins> FROM <ns>[.<set>]

SELECT <bins> FROM <ns>[.<set>] WHERE <bin> = <value>

        SELECT <bins> FROM <ns>[.<set>] WHERE <bin> BETWEEN <lower> AND <upper>

        SELECT <bins> FROM <ns>[.<set>] WHERE PK = <key>

        SELECT <bins> FROM <ns>[.<set>] IN <indextype> WHERE <bin> = <value>

        SELECT <bins> FROM <ns>[.<set>] IN <indextype> WHERE <bin> BETWEEN <lower> AND <upper>

        SELECT <bins> FROM <ns>[.<set>] IN <indextype> WHERE <bin> CONTAINS <GeoJSONPoint>

        SELECT <bins> FROM <ns>[.<set>] IN <indextype> WHERE <bin> WITHIN <GeoJSONPolygon>

 

 

'기타 > 메모' 카테고리의 다른 글

DB 이중화  (0) 2020.07.07