SparkSQL: not found value expr
<p>I'm having some problems in building a simple application with Spark SQL. What I want to do is to add a new column to a <code>DataFrame</code>. Thus, I have done:</p>

<pre><code>val sqlContext=new HiveContext(sc)
import sqlContext._
// creating the DataFrame
correctDF.withColumn("COL1", expr("concat('000',COL1)") )
</code></pre>

<p>but when I build it with sbt it throws the exception:</p>

<pre><code>not found: value expr
</code></pre>

<p>(and also Eclipse complains about it)</p>

<p>Instead in the <code>spark-shell</code> it works like a charm.</p>

<p>In my build.sbt file I have:</p>

<pre><code>scalaVersion := "2.10.5"

libraryDependencies += "org.apache.spark" % "spark-core_2.10" % "1.6.0" % "provided"

libraryDependencies += "org.apache.spark" % "spark-sql_2.10" % "1.6.0" % "provided"

libraryDependencies += "org.apache.spark" % "spark-hive_2.10" % "1.6.0" % "provided"
</code></pre>

<p>I've added the last line after I read a post, but nothing changed...</p>

<p>Can someone help me?</p>