Neel Phadnis neelp-git

## composite_batch.csv

          
            SQL
             Aerospike

            
              (SELECT bins1 FROM namespace1.set1 WHERE id IN key-list1) 
 UNION 
 (SELECT bins2 FROM namespace2.set2 WHERE id IN key-list2) 
 UNION ...
              void Client::get(BatchPolicy policy, List<BatchRead> records)

## create_udf.csv

          
            SQL
             Aerospike

            
              CREATE StoredProcedure
              Client::register(Policy policy, String clientPath, String serverPath, Language.LUA)

## drop_index.csv

          
            SQL
             Aerospike

            
              DROP Index
              dropIndex(Policy policy, String namespace, String setName, String indexName)

## create_index.csv

          
            SQL
             Aerospike

            
              CREATE Index
              createIndex(Policy policy, String namespace, String setName, String indexName, String binName,IndexType indexType)

## truncate_set.csv

          
            SQL
             Aerospike

            
              TRUNCATE namespace.set
              void Client::truncate(policy, namespace, set, beforeLastUpdate=null)

## truncate_namespace.csv

          
            SQL
             Aerospike

            
              TRUNCATE namespace
              void Client::truncate(policy, namespace, set=null, beforeLastUpdate=null)

## multi_op.csv

          
            SQL
             Aerospike

            
              SELECT fn1(bin1), …FROM namespace.set WHERE id=key +  UPDATE namespace.set SET (bin1=fn_n(bin_n), ...) WHERE id=key
              Record Client::operate( WritePolicy policy, Key key, Operation... operations)

## udf.csv

          
            SQL
             Aerospike

            
              EXEC StoredProcedure @arg1 = val1, @arg2 = val2, …
              Object Client::execute(WritePolicy policy, Key key, String packageName, String functionName, Value... functionArgs)

## udf_write.csv

          
            SQL
             Aerospike

            
              UPDATE namespace.set SET (bin1=fn1(args), ...) WHERE condition  + DELETE FROM namespace.set WHERE condition
              ExecuteTask Client::execute(WritePolicy policy, Statement statement, String packageName, String functionName, Value... functionArgs)

## predicate_based_write.csv

          
            SQL
             Aerospike

            
              UPDATE namespace.set SET (bin=value, ...) WHERE condition + DELETE FROM namespace.set WHERE condition
              Client::execute(WritePolicy policy, Statement statement)
	SQL	Aerospike
	(SELECT bins1 FROM namespace1.set1 WHERE id IN key-list1) UNION (SELECT bins2 FROM namespace2.set2 WHERE id IN key-list2) UNION ...	void Client::get(BatchPolicy policy, List<BatchRead> records)
	SQL	Aerospike
	CREATE StoredProcedure	Client::register(Policy policy, String clientPath, String serverPath, Language.LUA)
	SQL	Aerospike
	DROP Index	dropIndex(Policy policy, String namespace, String setName, String indexName)
	SQL	Aerospike
	CREATE Index	createIndex(Policy policy, String namespace, String setName, String indexName, String binName,IndexType indexType)
	SQL	Aerospike
	TRUNCATE namespace.set	void Client::truncate(policy, namespace, set, beforeLastUpdate=null)
	SQL	Aerospike
	TRUNCATE namespace	void Client::truncate(policy, namespace, set=null, beforeLastUpdate=null)
	SQL	Aerospike
	SELECT fn1(bin1), …FROM namespace.set WHERE id=key + UPDATE namespace.set SET (bin1=fn_n(bin_n), ...) WHERE id=key	Record Client::operate( WritePolicy policy, Key key, Operation... operations)
	SQL	Aerospike
	EXEC StoredProcedure @arg1 = val1, @arg2 = val2, …	Object Client::execute(WritePolicy policy, Key key, String packageName, String functionName, Value... functionArgs)
	SQL	Aerospike
	UPDATE namespace.set SET (bin1=fn1(args), ...) WHERE condition + DELETE FROM namespace.set WHERE condition	ExecuteTask Client::execute(WritePolicy policy, Statement statement, String packageName, String functionName, Value... functionArgs)
	SQL	Aerospike
	UPDATE namespace.set SET (bin=value, ...) WHERE condition + DELETE FROM namespace.set WHERE condition	Client::execute(WritePolicy policy, Statement statement)