thank you sir
sql("select `_1` as firstcolumn from items")
is there anyway one can keep the csv column names using databricks when mapping
val r = df.filter(col("paid") > "").map(x =>
(x.getString(0),x.getString(1).....)
can I call example x.getString(0).as.(firstcolumn) in above when mapping if
possible so columns will have labels
On Thursday, 24 March 2016, 0:18, Michael Armbrust <mich...@databricks.com>
wrote:
You probably need to use `backticks` to escape `_1` since I don't think that
its a valid SQL identifier.
On Wed, Mar 23, 2016 at 5:10 PM, Ashok Kumar <ashok34...@yahoo.com.invalid>
wrote:
Gurus,
If I register a temporary table as below
r.toDFres58: org.apache.spark.sql.DataFrame = [_1: string, _2: string, _3:
double, _4: double, _5: double]
r.toDF.registerTempTable("items")
sql("select * from items")res60: org.apache.spark.sql.DataFrame = [_1: string,
_2: string, _3: double, _4: double, _5: double]
Is there anyway I can do a select on the first column only
sql("select _1 from items" throws error
Thanking you
