| { | |
| "statement": "SELECT * FROM MYTABLE", | |
| "resultSetMetaData": { | |
| "format": "arrowv1" | |
| }, | |
| "timeout": 60, | |
| "database": "MYDATABASE", | |
| "schema": "MYSCHEMA", | |
| "warehouse": "MYWAREHOUSE", | |
| "role": "MYROLE" |
| import pandas as pd | |
| import pyarrow as pa | |
| file_path = 'fruit.arrow' | |
| stream_path = 'fruit.arrows' | |
| df = pd.DataFrame(data={'fruit': ['apple', 'apple', 'apple', 'orange', 'orange', 'orange'], | |
| 'variety': ['gala', 'honeycrisp', 'fuji', 'navel', 'valencia', 'cara cara'], | |
| 'weight': [134.2 , 158.6, None, 142.1, 96.7, None]}) |
First start an HTTP server to serve Arrow IPC stream data. You can do this using one of the server examples
in HTTP GET Arrow Data: Simple Examples
or simply by starting a Python HTTP server in the same directory where you have an Arrow IPC stream file
(named file.arrows in this example).
python -m http.server 8008Download the attached Python script script.py. You might need to do chmod +x script.py to make it executable.