Skip to main content
Question

Use OFFSET in amazon s3 select query.

SudarshanShinde
Fan

Hi Team,
We are using groovy_scripting origin to read files from s3 bucket. But problem is that we are not able to apply offset in sql query used in code. Can u help us to provide some way to apply offset in sql query. I am attaching code snippet that is working but we are not able to apply offset in it.

 

 

2 replies

dima
StreamSets Employee
Forum|alt.badge.img
  • dimaStreamSets Employee
  • StreamSets Employee
  • 83 replies
  • August 8, 2023

Hi @SudarshanShinde ,

 

Is there a specific reason you're using a scripting origin and not simply the Amazon S3 origin to read objects from your bucket?

SudarshanShinde
Fan

Hi @dima it is client requirement to use groovy scripting as a origin.

Reply


Terms & Conditions