@himanshu1234567
I got this below code snippet from google with sql query on s3 object and it works fine for it.
May i know if the code is working fine in your local setup .
# start client with s3
s3 = boto3.client('s3', region_name='us-east-1')
# define file location and name
bucket_name = 'MY-BUCKET-NAME'
filename = 'test.csv'
# create SQL expression to query by date using column index
sql_exp = "SELECT * FROM s3object s LIMIT 1"
# should we use header names to filter
use_header = False
# return CSV of unpacked data
file_str = query_csv_s3(s3, bucket_name, filename, sql_exp, use_header)
# read CSV to dataframe
df = pd.read_csv(StringIO(file_str))
# print column names
print(list(df.columns))
@Bikram where u are using offset here, my problem is that sql query is not supporting offset.Can we use offset in your code?
@Bikram we need groovy/java code?
@Bikram above code u pasted is groovy?