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

Elastic Stack Elasticsearch
1

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

df
df828×36 6.69 KB

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.
data
please help :slightly_smiling_face:
i referred this topic Problem with SQL Query with special character in field and table name

2

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

use ` to escape special characters. below is my query
df

1 Like
3

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