if i have run any sql query without column name space then It is successfully run.
If i have run any sql query have space in column name that time it showing sql parse error.
Example 1. without space in column name that one executed
sql = SELECT t0.,t1. FROM 106659841v1 t0 INNER JOIN 106659841v1 t0 ON (t0.customerid = t0.customerid)
Example 2 if i have run sql query with space in column name that one showing error
sql query = SELECT t0.,t1. FROM 109248515v1 t0 INNER JOIN 109248514v1 t1 ON (t0.customerid = t1.order id
)
error = com.alibaba.druid.sql.parser.ParserException: syntax error, expect RPAREN, actual IDENTIFIER order id
if that one query execute in mysql or any database that time is run successfully.
that one issue in java prog. lang.
code : - SearchDao searchDao = new SearchDao(esClient);
SqlElasticRequestBuilder explain = searchDao.explain(query).explain();
ElasticJoinExecutor executor = ElasticJoinExecutor.createJoinExecutor(searchDao.getClient(),explain);
executor.run();
esClient is config. of elasticsearch database.
query is simple sql query.
Please give me any solution and thanks for answer