/
vshmidt
/
minio
Обзор
Документация
Войти
/
vshmidt
/
minio
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
docs/select/select.py
33 строки
1 KB
Harshavardhana
Add select docs and fix return values for Select API (#6300)
18 авг 2018, 03:11
18 авг 2018, 03:11
5a4a577
Код
Авторство
О чём код?
#!/usr/bin/env/env python3 import boto3 s3 = boto3.client('s3', endpoint_url='http://localhost:9000', aws_access_key_id='minio', aws_secret_access_key='minio123', region_name='us-east-1') r = s3.select_object_content( Bucket='mycsvbucket', Key='sampledata/TotalPopulation.csv.gz', ExpressionType='SQL', Expression="select * from s3object s where s.Location like '%United States%'", InputSerialization={ 'CSV': { "FileHeaderInfo": "USE", }, 'CompressionType': 'GZIP', }, OutputSerialization={'CSV': {}}, ) for event in r['Payload']: if 'Records' in event: records = event['Records']['Payload'].decode('utf-8') print(records) elif 'Stats' in event: statsDetails = event['Stats']['Details'] print("Stats details bytesScanned: ") print(statsDetails['BytesScanned']) print("Stats details bytesProcessed: ") print(statsDetails['BytesProcessed'])