Apache Parquet VS ShellNewHandler

• Columnar Storage
  Apache Parquet uses columnar storage, which allows for efficient retrieval of only the data you need, reducing I/O and improving query performance on large datasets.
• Compression
  Parquet files support efficient compression and encoding schemes, resulting in significant storage savings and less data to transfer over the network.
• Compatibility
  It is compatible with the Hadoop ecosystem, including tools like Apache Spark, Hive, and Impala, making it versatile for big data processing.
• Schema Evolution
  Parquet supports schema evolution, allowing changes to the schema without breaking existing data, which helps in maintaining long-lived data pipelines.
• Efficient Read Performance for Aggregations
  Due to its columnar layout, Parquet is highly efficient for processing queries that aggregate data across columns, such as SUM and AVERAGE.

Possible disadvantages

• Write Performance
  Writing data to Parquet can be slower compared to row-based formats, particularly for small inserts or updates, due to the overhead of encoding and compression.
• Complexity in File Management
  Managing and partitioning Parquet files to optimize performance can become complex, particularly as datasets grow in size and complexity.
• Not Ideal for All Workloads
  Workloads that require frequent row-level updates or involve small queries might be less efficient with Parquet due to its columnar nature.
• Learning Curve
  The need to understand the nuances of columnar storage, encoding, and compression can pose a learning curve for teams new to Parquet.

No features have been listed yet.

No analysis of Apache Parquet yet.

• Can you build observability ingestion on S3 alone — no Kafka, no disks, no coordination layer?

  Apache Iceberg fits these requirements well. Iceberg stores data as immutable Apache Parquet files and adds them through atomic commits, so readers always see a consistent snapshot. A separate metadata layer prunes files by their... - Source: dev.to / 4 months ago

• Zeroserve: A zero-config web server you can script with eBPF

  Depends on the domain. There's a bunch of sciences using large datasets served up efficiently using static file formats, e.g., https://zarr.dev/ and https://parquet.apache.org/. - Source: Hacker News / 5 months ago

• What Are Table Formats and Why Were They Needed?

  The data files themselves are still standard Parquet or ORC. The table format adds a metadata layer on top that gives those files the properties of a database table. - Source: dev.to / 6 months ago

View more

• I recently got libreoffice, but now the new option in right click looks like a mess. Can someone help me get rid of them please?

  Use Shell New Handler. Run the portable app and simply untick the items you don't want to appear in your new context menu. Source: about 4 years ago

• This menu should be easy to add/remove programs to... Who is really creating Access Databases from this menu often enough to keep it here? (Not me!) Is there an easy way to edit this?

  I've always used ShellNewHandler for this. It's a really simple portable utility that allows you to remove most of the items from that menu. Tested it out on Windows 11 and it's still compatible. Source: over 5 years ago