I tried below query to fetch data from first two indexes by creating an alias as well, but that is also not working
POST _sql?format=txt
{
"query": """
SELECT MAX(age.keyword),MAX(cc.keyword),MAX(exp.keyword),MAX(name.keyword),id.keyword from indexes GROUP by id.keyword
"""
}
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.