Skip to content

feat: implement sql command #3

@overtrue

Description

@overtrue

Description

Implement the sql command for querying S3 objects using S3 Select.

Requirements

  • Execute SQL queries on CSV, JSON, or Parquet files stored in S3
  • Stream query results to stdout
  • Requires S3 Select feature support

Acceptance Criteria

  • rc sql <path> --query "SELECT * FROM s3object" - Execute SQL query
  • Support input formats: CSV, JSON, Parquet (--input-format)
  • Support output formats: CSV, JSON (--output-format)
  • Support compression (GZIP, BZIP2) (--compression)
  • Return EXIT_UNSUPPORTED_FEATURE (7) when S3 Select is not supported
  • Support --force flag to bypass capability detection

Notes

This is a capability-dependent feature. S3 Select is not supported by all S3-compatible storage providers.

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions