apache spark - How to express a column whose name contains spaces in SparkSql 1.3.1? -
we have tried wrapping column name brackets [column name]
, single & double quotes, , backticks, none of them works.
does sparksql support columns name contains spaces?
thank you!
backticks seem work fine:
scala> val df = sc.parallelize(seq(("a", 1))).todf("foo bar", "x") df: org.apache.spark.sql.dataframe = [foo bar: string, x: int] scala> df.registertemptable("df") scala> sqlcontext.sql("""select `foo bar` df""").show foo bar
same dataframe
api:
scala> df.select($"foo bar").show foo bar
so looks supported, although doubt recommended.
Comments
Post a Comment