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.toDF > res58: 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 >