Hi,
installed version details :
logstash-6.6.1-1.noarch
elasticsearch-6.7.0-1.noarch
kibana-6.6.1-1.x86_64
I am trying to configure a ODBC connection to my elastic node but I get error when setting up the connection , I tried to put "xpack.security.enabled: false" in elasticsearch.yml but no luck
Please format your code, logs or configuration files using </> icon as explained in this guide and not the citation button. It will make your post more readable.
Or use markdown style like:
```
CODE
```
This is the icon to use if you are not using markdown format:
There's a live preview panel for exactly this reasons.
Lots of people read these forums, and many of them will simply skip over a post that is difficult to read, because it's just too large an investment of their time to try and follow a wall of badly formatted text.
If your goal is to get an answer to your questions, it's in your interest to make it as easy to read and understand as possible.
Anyway, you need a platinum license to run ODBC driver. Or a trial.
Thanks for the post readability suggestion.
Is trial license worth some cost or it can be attained free for some period of time. If free then can you please let me know the procedure to include the license for ODBC.
I was successfully able to connect to elastic via my BI tool and pull the tables data into my tool.
However surprisingly when I tried to join two tables I got below error:
[Elastic][EsODBC 6.7.0(1b41af1+,u,r) Driver]parsing_exception: line 43:4: Queries with JOIN are not yet supported
Unable to create extract
Is this something not supported in elastic SQL layer yet ? If not supported then is there any development going around this feature.
Sorry for being late to reply on this !
I have an index with data as :
{
"_index" : "qstat-2019.03.29",
"_type" : "doc",
"_source" : {
"Job_Number" : "150153525",
"Job_State" : "pending",
"hard_req_queue" : "all.q",
"Submission_time" :
}
As you could see that "Submission_time" field is empty which I would get from another dataset and was getting that data set into elastic into a different index and trying to create join between both the indexes based on "Job_Number" field. But as you said joins are not supported so is there a way that I can stream in the second data source and update the value of "Submission_time" in above shown index by matching the "job_Number" field.
Kindly excuse if I am asking some stupid question, as I am pretty new in elastic world and might be my thoughts are generating by comparing to relational databases.
My both the data sources are xml files so I am parsing the xml file in logstash before writing the data into elastic. So, I would parse the second xml in logstash to extract "job_Number" and "Submission_time" and write the later to the index doc shown above based on the matching "job_Number"
The best thing to do if possible is to do joins at index time. Index in the same document data coming from both sources for example.
But all that topic is definitely a new question so I suggest that you open a new discussion regarding this as it's not anymore "ODBC connection to elastic".
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.