This discussion is archived
8 Replies Latest reply: Jun 19, 2013 1:31 PM by JosephMeier RSS

nosql_stream returns nothing...invalid config or empty store?

JosephMeier Newbie
Currently Being Moderated

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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points