Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Missing value although using Batch #1651

Closed
ss682 opened this issue Nov 6, 2017 · 1 comment
Closed

Missing value although using Batch #1651

ss682 opened this issue Nov 6, 2017 · 1 comment

Comments

@ss682
Copy link

ss682 commented Nov 6, 2017

I am using batch node to query data from InfluxDB over a specified period. The following is a short example:

 batch
                
                |query(
                        '''
                       SELECT "timeUntilEndOfLicence",
                                 

                       FROM "artifactory__systems"."autogen".Artifactory
                        '''
                        )
                        .period(9m)
                        .every(20s)

                  |last('timeUntilEndOfLicence')
                         .as('timeUntilEndOfLicence')
..............

In this Tickscript I do calculations in an eval-node with the field timeUntilEndOfLicence. The result field called "licenceStatus" is pushed to InfluxDB to the same database with the same measurement (artifactory__systems"."autogen".Artifactory). In another Tickscript I do the same calculating for another field and push the result field called "storageStatus" to InfluxDB. All works fine.

In another Tickscript I want to combine "licenceStatus" and "storageStatus" to do further processing. The way I access these fields is exactly the same as stated above using batch, period and last node. Nevertheless kapacitor log shows that the fields licenceStatus and storageStatus are missing. Checking the logs and InfluxDB entries these fields seem to be available though.

Here #1217 they had a similar problem and suggest using batch instead of stream as solution. It seems that there still are some problems with batch.

@desa
Copy link
Contributor

desa commented Nov 6, 2017

@ss682 I think this may be better suited for https://community.influxdata.com/. Can you please ask the question there so that we can answer it appropriately.

@desa desa closed this as completed Nov 6, 2017
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants