@timestamp field problem while reading data from elasticsearch using spark-sql

i am trying to read data from elasticsearch using spark-sql, my index contains @timestamp field. below is my query

the field name contains a special character so i am escaping it. the problem here is i am not getting any data in my output for the field @timestamp, below is my output.
please help :slightly_smiling_face:
i referred this topic Problem with SQL Query with special character in field and table name

found the solution from official spark documentation Identifiers - Spark 3.1.1 Documentation

use ` to escape special characters. below is my query

1 Like

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.