Skip to content

Latest commit

 

History

History
29 lines (23 loc) · 701 Bytes

README.md

File metadata and controls

29 lines (23 loc) · 701 Bytes

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