Loading big native dataframes in JavaScript is finally awesome. apache-arrow
provides an easy, modern, and efficient zero-copy JS interface to parse, iterate, and access Apache Arrow columnar data on CPUs (GPU support via GoAI is occurring in parallel).
apache-arrow
is tested on Apache's sample Arrow files and MapD Core's Arrow output, and powers much of Graphistry's GPU visual analytics platform. It is in active development by Graphistry for its GPU client/cloud visual graph analytics platform.
This project has been developed outside the Apache Software Foundation, but an effort to transfer IP and ownership to the ASF is underway.
install
npm install apache-arrow
What's Arrow?
Apache Arrow is a columnar memory layout specification for encoding vectors and table-like containers of flat and nested data. The Arrow spec aligns columnar data in memory to maximize caches and take advantage of the latest SIMD (Single input multiple data) and GPU operations on modern processors.
Apache Arrow is the emerging standard for large in-memory columnar data (Spark, Pandas, Drill, ...). By standardizing on a common interchange format, big data systems can reduce the costs and friction associated with cross-system communication.
Related Projects
- Apache Arrow -- Arrow columnar format
- GoAI -- Arrow standard extensions for GPUs
- rxjs-mapd -- Library for querying MapD Core in node
Examples
Get a table from an Arrow file on disk
import { readFileSync } from 'fs';
import { Table } from 'apache-arrow';
const arrow = readFileSync('simple.arrow');
const table = Table.from(arrow);
console.log(table.toString());
/*
foo, bar, baz
1, 1, aa
null, null, null
3, null, null
4, 4, bbb
5, 5, cccc
*/
Create a Table when the Arrow file is split across buffers
import { readFileSync } from 'fs';
import { Table } from 'apache-arrow';
const table = Table.from(...[
'latlong/schema.arrow',
'latlong/records.arrow'
].map((file) => readFileSync(file)));
console.log(table.toString());
/*
origin_lat, origin_lon
35.393089294433594, -97.6007308959961
35.393089294433594, -97.6007308959961
35.393089294433594, -97.6007308959961
29.533695220947266, -98.46977996826172
29.533695220947266, -98.46977996826172
*/
Columns are what you'd expect
import { readFileSync } from 'fs';
import { Table } from 'apache-arrow';
const table = Table.from(...[
'latlong/schema.arrow',
'latlong/records.arrow'
].map(readFileSync));
const column = table.getColumn('origin_lat');
const typed = column.slice();
assert(typed instanceof Float32Array);
for (let i = -1, n = column.length; ++i < n;) {
assert(column.get(i) === typed[i]);
}
Use with MapD Core
import MapD from 'rxjs-mapd';
import { Table } from 'apache-arrow';
const port = 9091;
const host = `localhost`;
const encrypted = false;
const username = `mapd`;
const password = `HyperInteractive`;
const dbName = `mapd`, timeout = 5000;
MapD.open(host, port, encrypted)
.connect(dbName, username, password, timeout)
.flatMap((session) =>
session.queryDF(`
SELECT origin_city
FROM flights
WHERE dest_city ILIKE 'dallas'
LIMIT 5`
).disconnect()
)
.map(([schema, records]) =>
Table.from(schema, records))
.subscribe((table) => console.log(
table.toString({ index: true })));
/*
Index, origin_city
0, Oklahoma City
1, Oklahoma City
2, Oklahoma City
3, San Antonio
4, San Antonio
*/
Contribute
See develop.md
Please create an issue if you encounter any bugs!
PR's welcome! Here's some ideas:
- API docs
- More Tests/Benchmarks
- Performance optimizations
- Arrows from node-streams and async-iterators
- GPU Arrows from node-opencl and node-cuda buffers
- Bindings to libgdf
packaging
apache-arrow
is written in TypeScript, but the project is compiled to multiple JS versions and common module formats. The base apache-arrow
package includes all the compilation targets for convenience, but if you're conscientious about your node_modules
footprint, don't worry -- we got you. The targets are also published under the @apache-arrow
namespace:
npm install @apache-arrow/es5-cjs
npm install @apache-arrow/es5-esm
npm install @apache-arrow/es5-umd
npm install @apache-arrow/es2015-cjs
npm install @apache-arrow/es2015-esm
npm install @apache-arrow/es2015-umd
npm install @apache-arrow/esnext-esm
npm install @apache-arrow/esnext-esm
npm install @apache-arrow/esnext-umd
why do we package like this?
The JS community is a diverse group with a varied list of target environments and tool chains. Publishing multiple packages accommodates projects of all types. Friends targeting the latest JS runtimes can pull in the ESNext + ESM build. Friends needing wide browser support and small download size can use the UMD bundle, which has been run through Google's Closure Compiler with advanced optimizations.
If you think we missed a compilation target and it's a blocker for adoption, please open an issue. We're here for you ❤️.
License
Apache 2.0