The features presented in this document are realized through extensions to the SQL language and thus require little or no semantic change for existing users.
In order to develop Java user defined functions, you need:
- The SQL-MapReduce SDK Java package, com.asterdata.ncluster.sqlmr, which is in the sqlmr-sdk-java.tar.gz archive.
- To develop scalar functions, you need the com.asterdata.ncluster.scalar package, which is in the sqlmr-sdk-java.tar.gz archive.
- To develop aggregate functions, you need the com.asterdata.ncluster.aggregator package, which is in the sqlmr-sdk-java.tar.gz archive.
- The ACT client – which has support for installing procedural code.
- Java JDK 1.8, Update 45 or newer – for compiling Java functions on your workstation.
- HTTP access to the queen node and the AMC – for viewing and managing SQL-MapReduce queries with the AMC, including queries that invoke procedures. To check SQL-MapReduce query execution, see Manage SQL-MapReduce Execution.