Question

Use OFFSET in amazon s3 select query.

  • 7 August 2023
  • 2 replies
  • 36 views

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

Userlevel 3
Badge

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?

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

Reply