Github user BrianOn99 commented on the issue:
https://github.com/apache/incubator-predictionio/pull/401
@mars Thanks for the help. Yes the jdbc driver is not loaded correctly,
though I have the jar downloaded. I need to add `export CLASSPATH` like this
in pio-shell
```
if [[ "$1" == "--with-spark" ]]
then
echo "Starting the PIO shell with the Apache Spark Shell."
# Get paths of assembly jars to pass to spark-shell
. ${PIO_HOME}/bin/compute-classpath.sh
shift
export CLASSPATH
${SPARK_HOME}/bin/spark-shell --jars
${ASSEMBLY_JAR},/PredictionIO-0.11.0-incubating/lib/spark/pio-data-jdbc-assembly-0.11.0-incubating.jar
$@
else
```
and then every thing works.
I note that `export CLASSPATH` exist in `bin/pio-class`, so in my
environment `pio status`, `pio train`, etc, can work, but `pio-shell` does not
call `bin/pio-class` so `CLASSPATH` is not exported. Is this fixed upstream or
my setting is wrong?
---
