[
https://issues.apache.org/jira/browse/TRAFODION-1668?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15040801#comment-15040801
]
ASF GitHub Bot commented on TRAFODION-1668:
-------------------------------------------
Github user kevinxu021 commented on a diff in the pull request:
https://github.com/apache/incubator-trafodion/pull/203#discussion_r46652845
--- Diff: core/conn/spj_init/README.md ---
@@ -0,0 +1,24 @@
+##How to build and initialize default SPJs
+###Build
+```
+cd $MY_SQROOT/../conn/spj_init
+make clean && make all
+```
+###Initialization
+```
+cds
+./init_spj.sql
+```
+###SPJ Example
+```
+DEFAULT_SPJ.HELP(INOUT COMMANDNAME VARCHAR)
+E.g.
+trafci>set param ?p1 help;
+trafci>call DEFAULT_SPJ.HELP(?p1)
+PUT - Upload a JAR. SHOWDDL PRODURE DEFAULT_SPJ.PUT for more info.
+LS - List JARs. SHOWDDL PRODURE DEFAULT_SPJ.LS for more info.
+LSALL - List all JARs. SHOWDDL PRODURE DEFAULT_SPJ.LSALL for more info.
+RM - Remove a JAR. SHOWDDL PRODURE DEFAULT_SPJ.RM for more info.
+RMREX - Remove JARs by a perticular pattern. SHOWDDL PRODURE
DEFAULT_SPJ.RMREX for more info.
+GETFILE - Upload a JAR. SHOWDDL PRODURE DEFAULT_SPJ.GETFILE for more info.
+```
--- End diff --
For build, Trafodion ID is not require. But the only required thing is to
upload the jar into every node on cluster for "create library". And Trafodion
ID should have READ permission on the JAR.
For initialization, anywhere SQLCI is available, whatever it's Tafodion ID.
By the way, sqlci can be replaced by trafci, then it can be initialized on
client-side.
> Cannot upload customer SPJ JARs
> -------------------------------
>
> Key: TRAFODION-1668
> URL: https://issues.apache.org/jira/browse/TRAFODION-1668
> Project: Apache Trafodion
> Issue Type: Improvement
> Reporter: Kevin Xu
> Assignee: Kevin Xu
>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
