Skip to content

monsterxx03/sqlpar

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

26 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

sqlpar

Use sql to query parquet file

    ./sqlpar -file test.parquet

    >> select user_id, age from test_schema where age > 1 limit 2
    user_id  age
    abc      12
    def      33

    ./sqlpar -file test.parquet -sql 'select user_id, age from test_schema where age > 1 limit 2'
    user_id  age
    abc      12
    def      33

Features

  • Basic select statement
  • Where clause support AND, OR, NOT, operators: >, >=, <, <=, =, !=, <>
  • Limit clause
  • show table statement
  • [] Order by clause
  • [] Column As syntax
  • [] Support nest column
  • [] Group by clause
  • [] Aggregate function
  • [] Column function
  • [] Export result as csv

About

Explore parquet file with sql, without spark!

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published