8 Replies Latest reply: Jun 19, 2013 3:31 PM by JosephMeier RSS

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

    JosephMeier

      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