Sqlpar
Explore parquet file with sql, without spark!
Install / Use
/learn @monsterxx03/SqlparREADME
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
- [x] Basic select statement
- [x] Where clause support AND, OR, NOT, operators: >, >=, <, <=, =, !=, <>
- [x] Limit clause
- [x]
show tablestatement - [] Order by clause
- [] Column As syntax
- [] Support nest column
- [] Group by clause
- [] Aggregate function
- [] Column function
- [] Export result as csv
Related Skills
oracle
345.4kBest practices for using the oracle CLI (prompt + file bundling, engines, sessions, and file attachment patterns).
prose
345.4kOpenProse VM skill pack. Activate on any `prose` command, .prose files, or OpenProse mentions; orchestrates multi-agent workflows.
Command Development
104.6kThis skill should be used when the user asks to "create a slash command", "add a command", "write a custom command", "define command arguments", "use command frontmatter", "organize commands", "create command with file references", "interactive command", "use AskUserQuestion in command", or needs guidance on slash command structure, YAML frontmatter fields, dynamic arguments, bash execution in commands, user interaction patterns, or command development best practices for Claude Code.
Plugin Structure
104.6kThis skill should be used when the user asks to "create a plugin", "scaffold a plugin", "understand plugin structure", "organize plugin components", "set up plugin.json", "use ${CLAUDE_PLUGIN_ROOT}", "add commands/agents/skills/hooks", "configure auto-discovery", or needs guidance on plugin directory layout, manifest configuration, component organization, file naming conventions, or Claude Code plugin architecture best practices.
