VRL language commands not working when we create those as a function and associated with a steam about openobserve HOT 10 CLOSED

Can you provide us more info on what your VRL looks like and some sample data. We need to be able to reproduce the issue in order to help.

from openobserve.

Hi Prabhatsharma,

Thanks for the reply.

https://playground.vrl.dev/?state=eyJwcm9ncmFtIjoiIyBQYXJzZSBIVFRQIHN0YXR1cyBjb2RlIGludG8gbG9jYWwgdmFyaWFibGVcbmh0dHBfc3RhdHVzX2NvZGUgPSBwYXJzZV9pbnQhKC5odHRwX3N0YXR1cylcblxuIyBBZGQgc3RhdHVzXG5pZiBodHRwX3N0YXR1c19jb2RlID49IDQwMCAmJiBodHRwX3N0YXR1c19jb2RlIDw9IDQwNSB7XG4gICAgZGVsKC4pXG59XG5pZiAoLnJlcXVlc3RfVVJMICE9IG51bGwpIFxue1xuICAgIGlmIGNvbnRhaW5zKHN0cmluZyEgKC5yZXF1ZXN0X1VSTCksIFwiL2FwaS9zeXN0ZW0vaGVhcnRiZWF0XCIpIHtcbiAgICAgICAgZGVsKC4pXG4gICAgfSBlbHNlIHtcbiAgICBcbiAgICAgICAgLnJlcV91cmxfc3BsaXQsZXJyb3IxPXNwbGl0KC5yZXF1ZXN0X1VSTCwgXCIvXCIpXG4gICAgICAgIC5tYWluID0gLnJlcV91cmxfc3BsaXRbMV1cbiAgICAgICAgLm1haW5fc3BsaXQsZXJyb3IyPXNwbGl0KC5tYWluLCBcIi1cIilcbiAgICAgICAgLnZhbDE9Lm1haW5fc3BsaXRbMF1cbiAgICAgICAgLnZhbDI9Lm1haW5fc3BsaXRbMl1cblxuICAgICAgICBkZWwoLnJlcV91cmxfc3BsaXQpXG4gICAgICAgIGRlbCgubWFpbl9zcGxpdClcblxuICAgIH1cbn0iLCJldmVudCI6eyJ0aW1lc3RhbXAiOiIyMDIzLTA4LTIzVDEwOjQ5OjU5LjQwOVRaIiwiaWQiOiIzMnFxamhhc2QzNHEzNG4iLCJ1c2VybmFtZSI6ImFub255bW91cyIsInJlcXVlc3RfbWV0aG9kIjoiR0VUIiwicmVxdWVzdF9VUkwiOiIvQ09ERS1HRU5FUklDLVRFU1QvYXBwbGljYXRpb24tMS5sb2cuanNvbiIsImFnZW50IjoiSmF2YSIsImh0dHBfc3RhdHVzIjoiMjIwIn0sImlzX2pzb25sIjpmYWxzZSwiZXJyb3IiOm51bGx9

Please look at the sample event and the VRL that we have created. As expected it produces the result.

The FluentD agent will push the data from our EC2 server and it will be similar to the input event that I have used for this process. Please help us.

Thanks,
R Vaidhy

from openobserve.

when we try any sample code inside the VRL editor, I receive the following error "Error: Search SQL execute error.
"

from openobserve.

Additionally , if I execute any if condition code for example I if run the below code, I get " Error: Search SQL execute error".

What I tried inside the VRL,

if (.request_user_aget == null) {
.opetations="SYSTEMS CALL"

}

Even this statement fails with the SQL execute error.

from openobserve.

this is a bug. We will take it up.

from openobserve.

@RVaidhy can you try below :

if (.request_user_aget == null) {
.opetations="SYSTEMS CALL"
}
.

Make sure you have . in end which returns the modified record , let us know if it fails

from openobserve.

Hi Oasisk,

Nice to hear from you and thanks for letting us know. Let me test and update you in short.

from openobserve.

Hi Oasisk,

We are good with the solution provided. Thanks so much. I am closing this ticket now.

from openobserve.

@oasisk We should allow the user input function like VRL playground, the last . should be optional because many users test it in vrl playground and then copy it to OpenObserve.

from openobserve.

added . at the end the function, closing

from openobserve.