Hello everyone,
I am having an issue that i cant seem to find a work around for. I have attempted to load the ~10K tweets file from the onlh sample loader example. I then tried to get the data into an external table using nosql_stream. My issue is that when I test the stream i see no data. To me this says either the data was not correctly loaded or i have a mistake in my config.xml which i published. here are my config.xml, nosql_stream, and nosql.dat
config.xml:
<config version="1">
<component name="publish" type="params">
<!-- Fill in appropriate values for
oracle.kv.exttab.connection.url and oracle.kv.exttab.connection.user
-->
<property name="oracle.kv.exttab.connection.url" value="jdbc:oracle:thin:@//oracledb1.psu-erie.bd.psu.edu:1521/orcl.psu-erie.bd.psu.edu" type="STRING"/><
property name="oracle.kv.exttab.connection.user" value="scott" type="STRING"/>
<property name="oracle.kv.exttab.tableName" value="nosql_data" type="STRING"/>
<!-- If you use a wallet to access your Oracle Instance, uncomment
this and fill in a suitable value for the
oracle.kv.exttab.connection.wallet_location
property. -->
<!--
<property name="oracle.kv.exttab.connection.wallet_location"
value="PATHNAME TO YOUR WALLET DIRECTORY" type="STRING"/>
-->
</component>
<component name="nosql_stream" type="params">
<!-- Fill in appropriate values for
oracle.kv.kvstore and oracle.kv.hosts
-->
<property name="oracle.kv.kvstore" value="kvstore" type="STRING"/>
<property name="oracle.kv.hosts" value="oracledb1.psu-erie.bd.psu.edu:5000" type="STRING"/>
<property name="oracle.kv.batchSize" value="100" type="INT"/>
<property name="oracle.kv.depth" value="PARENT_AND_DESCENDANTS" type="STRING"/>
<property name="oracle.kv.parentKey" value="/user" type="STRING"/>
<property name="oracle.kv.keyDelimiter" value="|" type="STRING"/>
<property name="oracle.kv.variableSizeBytes" value="0" type="INT"/>
</component>
</config>
nosql_stream:
#!/bin/bash
#
# See the file LICENSE for redistribution information.
#
# Copyright (c) 2010, 2013 Oracle and/or its affiliates. All rights reserved.
#
# Fill in site-appropriate values for PATH, KVHOME, and CLASSPATH
# This script will be executed by the Oracle Database server.
# If you are using user-specified Formatters, by sure to include their home
# in the CLASSPATH.
#
export PATH="/usr/java/jre1.7.0_21/bin"
export KVHOME="/home/oracle/kv-2.0.39"
export CLASSPATH="$KVHOME/lib/kvstore.jar"
java oracle.kv.exttab.Preproc $*
nosql.dat:
<config version="1">
<component name="publish" type="params" validate="true">
<property name="oracle.kv.exttab.connection.url" value="jdbc:oracle:thin:@//oracledb1.psu-erie.bd.psu.edu:1521/orcl.psu-erie.bd.psu.edu" type="STRING"/>
<property name="oracle.kv.exttab.tableName" value="nosql_data" type="STRING"/>
<property name="oracle.kv.exttab.connection.user" value="scott" type="STRING"/>
</component>
<component name="nosql_stream" type="params" validate="true">
<property name="oracle.kv.variableSizeBytes" value="0" type="INT"/>
<property name="oracle.kv.hosts" value="oracledb1.psu-erie.bd.psu.edu:5000" type="STRING"/>
<property name="oracle.kv.exttab.totalExternalTableFiles" value="1" type="INT"/>
<property name="oracle.kv.batchSize" value="100" type="INT"/>
<property name="oracle.kv.exttab.externalTableFileNumber" value="0" type="INT"/>
<property name="oracle.kv.keyDelimiter" value="|" type="STRING"/>
<property name="oracle.kv.parentKey" value="/user" type="STRING"/>
<property name="oracle.kv.depth" value="PARENT_AND_DESCENDANTS" type="STRING"/>
<property name="oracle.kv.kvstore" value="kvstore" type="STRING"/>
</component>
</config>
Message was edited by: 1011669