Skip to content

Instantly share code, notes, and snippets.

@greenlion

greenlion/gist:f876f4cf7f819ff3df5e

Last active August 29, 2015 14:15
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save greenlion/f876f4cf7f819ff3df5e to your computer and use it in GitHub Desktop.
Save greenlion/f876f4cf7f819ff3df5e to your computer and use it in GitHub Desktop.
Download ZIP
FastBit UDF Specification
Raw
gistfile1.cpp
/*
FastBit UDF for MySQL (c) 2015 Justin Swanhart
Specification 1.0-DRAFT
*/
/*
fb_create(table_dir=>'/path/to/fastbit/data',colspec=>'c1:int,c2:int');
fb_load(table_dir=>'/path/to/fastbit/data', datafile=>'/path/to/file/to/load.txt');
fb_query(table_dir=>'/path/to/fastbit/data',query_string=>'select count(*) where c1 between 1 and 10', temp_dest=>'temporary_table_name');
fb_hits(table_dir=>'/path/to/fastbit/data',query_string=>'select count(*) where c1 between 1 and 10', temp_dest=>'temporary_table_name');
fb_delete(table_dir=>'/path/to/fastbit/data',where_clause=>'c1 between 1 and 10');
fb_delete_rid(table_dir=>'/path/to/fastbit/data',rid=>1);
fb_insert(table_dir=>'/path/to/fastbit/data',CSV_data=>'1,1');
*/
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment