# How can trace two column in single sql query(logstash)

**URL:** <https://discuss.elastic.co/t/how-can-trace-two-column-in-single-sql-query-logstash/202497>\
**Category:** Logstash\
**Created:** [October 7, 2019, 8:12am UTC](https://discuss.elastic.co/t/how-can-trace-two-column-in-single-sql-query-logstash/202497 "2019-10-07T08:12:18Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![rameshkr1994](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rameshkr1994/32/59029_2.png) [@rameshkr1994](https://discuss.elastic.co/u/rameshkr1994)\
**Post date:** [October 7, 2019, 8:12am UTC](https://discuss.elastic.co/t/how-can-trace-two-column-in-single-sql-query-logstash/202497/1 "2019-10-07T08:12:19Z")

</div>

Dear All.

i have sql query that contain union operation with different join and table.

> SELECT DISTINCT S.HEALTHRECORDKEY,NULL PRODUCTCODE,S.FIRSTNAME,S.LASTNAME,NULL DRUGDESCRIPTION,  
> PUL.LABTEST\_TYPE\_DESC,PUL.LABTEST\_DATE, PUL.DIAG\_SERVICE\_LOCATION,PUL.LABTEST\_RESULT\_DATE , PUL.LABTEST\_ID,null  
> FROM EDW.CONSENT.BENEFICIARY\_DETAILS S  
> INNER JOIN CDR.PHR\_USER\_HOSPITALIZATION PU ON S.HEALTHRECORDKEY = PU.HEALTHRECORDKEY  
> INNER JOIN CDR.ORDER\_INFO OI ON PU.HOSPITALIZATION\_ID = OI.HOSPITALIZATION\_ID  
> INNER JOIN CDR.PHR\_USER\_LABTEST PUL ON OI.ORDER\_ID = PUL.ORDER\_ID  
> UNION -------------------------------  
> SELECT DISTINCT S.HEALTHRECORDKEY,PRODUCTCODE,S.FIRSTNAME,S.LASTNAME,DRUGDESCRIPTION,NULL,NULL,NULL,NULL , null,pm.id as id  
> FROM EDW.CONSENT.BENEFICIARY\_DETAILS S  
> INNER JOIN EDW.CDR.ERX\_PATIENT\_MEDICATION PM ON S.HEALTHRECORDKEY = PM.HEALTHRECORDKEY"

Note :- how can i get only latest data from sql server into Elasticsearch.

there is two unique column in this query:-  
LABTEST\_ID (first query)  
union  
pm.id as id(second query).  
i tried with below:-

> tracking\_column =\> "id"  
> use\_column\_value =\> true  
> schedule =\> "\*/5 \* \* \* \* \*"

> [2019-10-07T13:15:41,599][WARN][logstash.inputs.jdbc] tracking\_column not found in dataset. {:tracking\_column=\>"id"}

please help me for this issue.

Thanks  
HadoopHelp

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [November 4, 2019, 8:12am UTC](https://discuss.elastic.co/t/how-can-trace-two-column-in-single-sql-query-logstash/202497/2 "2019-11-04T08:12:20Z")

</div>

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