(r16) ParquetInAstronomy < IVOA

IVOA Web>IvoaApplications>ParquetInAstronomy (revision 16) (raw view)~~EditAttach~~
---+ Parquet in IVOA

<br />%TOC%

---++ VOParquet Note

The [[https://www.ivoa.net/documents/Notes/VOParquet/][VOParquet Note]], published on 16 Jan 2025, describes use of VOTable within Parquet files to associate rich semantic (VOTable) metadata with the (parquet) data.

---+++ Implementation Status

The following *implementations* of the VOParquet convention exist. Please add to this list if you know of others.

   * TOPCAT/STILTS/STIL: implementation in public release since 7 March 2025 (STIL 4.3-2, STILTS 3.5-2, TOPCAT 4.10-3)
      * Writes VOParquet metadata into output parquet files by default; uses VOParquet metadata from input files when reading if present.
      * Believed fully compliant with VOParquet Note v1.0.
      * A small example output file is attached: [[%ATTACHURL%/skysim10.parquet][skysim10.parquet]] (produced like this: <code>stilts tpipe in=:skysim:10 out=skysim10.parquet</code>)
      * Note not all distributions come with (bloated) parquet support libraries - you may need [[http://www.starlink.ac.uk/topcat/topcat-extra.jar][topcat-extra.jar]]
   * !OpenCADC TAP server implementation (in-progress, ready early Jan 2025). PR here: https://github.com/opencadc/tap/pull/181
      * For queries where RESPONSEFORMAT specifies Parquet, Parquet file produced with metadata in enclosed VOTable as per the VOParquet note.
      * If the server encounters an error while constructing and streaming out the Parquet file, the client will receive text/plain message describing the error. Since the output stream is already open at this point (and the response code cannot be modified) we think it's the best it can do, but we are open to other suggestions.
      * Will be available in all instances of CADC TAP services including YouCat for user-managed tables.
   * !VOTableR
      * R-based tools to read VOTable and VOParquet; see [[https://github.com/asgr/VOTableR]] - _in progress_
   * ESAC Science Data Center
      * ESDC are operating code that writes VOParquet files for Gaia data.  This has been developed by Enrique Utrilla.
      * The VOParquet files pass validation by the STILTS validator.
      * Files in this format will be used internally for ESDC/DPAC processing, and it will be published as the format in which bulk downloads are offered for Gaia DR4

---+++ Validator

A VOParquet *validator* is available:

   * There is a new STILTS command [[http://www.starlink.ac.uk/stilts/sun256/parqlint.html][parqlint]] in STILTS v3.5-2 and later
   * Invoke it like this: <code>stilts parqlint &lt;voparquet-filename&gt;</code> (note not all stilts installations come with parquet libraries; you may need to do =java -jar topcat-extra.jar -stilts ...=)
   * It checks that the key-value entries look OK, does full [[http://www.starlink.ac.uk/stilts/sun256/votlint.html][votlint]] validation on the embedded VOTable, and reports on any discrepancies between the VOTable metadata and the parquet data
   * It has a few optional parameters; see the docs for more details
   * One option useful for debugging is being able to test an external data-less VOTable as if it were attached to the parquet file - see the <code>votable</code> parameter.

---++ Parquet and DALi

The current draft of !DALI 1.2 has added a new row to the =RESPONSEFORMAT= table, introducing the alias =parquet= for the parquet MIME type =application/vnd.apache.parquet=.  That means that for !DALI services offering parquet output, clients can request that format by providing the parameter <code>RESPONSEFORMAT=parquet</code>.  See [[https://github.com/ivoa-std/DALI/pull/43/commits/d0f6df3e][DALI PR#43]].

---++ Documents and Presentations
   * [[%PUBURL%/IVOA/InterOpNov2023TDIG/Parquet-VOTable-20231111.pdf][Presentation from Tucson Interop Nov 2023]] (Gregory D-F)
   * [[%ATTACHURL%/Bulk_download_for_DR4-public.pdf][DPAC/Gaia policy on bulk downloads Oct 2024]] (Jos de Bruijne)
   * [[%PUBURL%/IVOA/InterOpNov2024Apps/votparquet.pdf][Presentation from Malta Interop Nov 2024]] (Mark T)
---
---++ Meetings

---+++ 5 November 2024 19:00 UTC Online meeting

22 Zoom participants

---++++ Agenda

The purpose of the meeting is to learn about different current Parquet-related efforts currently under way and identify synergies that can be channeled into possibly new IVOA standards.

   * Around the table short description of the groups and Parquet-related projects
   * Mark Taylor [[%ATTACHURL%/votparquet-telecon-2024-11-05.pdf][presentation on VOTable metadata with Parquet files]]
   * Jos de Bruijne Parquet Compression algorithms in Parquet
   * Path forward - Malta Interop

---++++ Meeting minutes

Active groups using Parquet techonology:
   * Jeff Burke (CADC) - Parquet format for TAP
   * Mario Juric (U of Washington) - Upload and download large Rubin catalogues
   * Vandana Desai (Caltech/IPAC) - Science with large catalogues inspired by Mario's work.
   * Jos De Bruijne (ESA) - ESA GAIA DR4 - Use Parquet format (instead of the current CSV format)
   * Pierre Le Sidaner (Observatoire de Paris) - Also GAIA mission. Appreciate data access by column
   * Gregory Dubois-Felsmann (Rubin) - Rubin very heavy use of Parquet internally and externally. Catalogue releases. Rich metadata in VOTable goes beyond UCDs and UTypes
   * Trey Roby (IPAC) - Firefly read and write Parquet file. Very good file. Pushing the edge of how big the files can be.
   * Mark Taylor presentation on adding VOTable rich metadata in Parquet

---++++ Questions and comments on the presentation

   * Gregory D-F: VOTable metadata is important for DataLink, no objection for adding encoding, version support is a must. Valid VOTable medata must comply with the spec. Parquet is not great to work multiple datasets but VOTable should support multiple tables. What happens if there’s a conflict between VOTable metadata nd Parquet metadata.
   * Mark T.: Cannot have an empty data element. VOTable Resource has a flag that can be used. Main table can be of type result and other resources can have other types (medatadat).
   * Trey R.: How to resolve inconsistencies between Parquet and VOTable. Parquet should have the last word.
   * Mario J: Important to specify how to do deal with inconsistencies between VOTabe metadata and Parquet metadata
   * Brigitta S: Prefers Parquet support first before generalization (FITS) Example files would be useful for implementation such as astroquery - ex multiple tables with the same file.
   * Jos DB: Compression algs. Should start thinking about this as it's one of the core strengths of Parquet
   * Gregory D-F. We need to define new TAP result formats. Is there a Parquet MIME type?
   * A few participants stressed the importance of moving fast with the adoption of Parquet in IVOA as a lot of projects are currently under way.
   * Marco M: Proposed the faster route of writing an IVOA Note for VOTable and Parquet and then explore generalizing it for other types (FITS) and turn it into a standard.

---++++ Actions:

   * Mark T. and Gregory D-F will start drafting the note
   * Mark T. will make his presentation available so that others can comment on it - [[%ATTACHURL%/votparquet-telecon-2024-11-05.pdf][done]]
   * Mark T. will present progress during the Apps session in Malta
   * Apps WG to support the efforst: create Twiki page with useful info, organize meetings post Interop as required, etc.

&lt;!--<br />      * Set ALLOWTOPICRENAME = IVOA.TWikiAdminGroup<br />--&gt;
Attachments
Topic attachments
I	Attachment	History	Action	Size	Date	Who	Comment
pdf	Bulk_download_for_DR4-public.pdf	r1	manage	903.4 K	2024-11-06 - 10:01	MarkTaylor	Gaia DR4 bulk download plans
parquet	skysim10.parquet	r1	manage	2.9 K	2024-12-17 - 12:45	MarkTaylor
pdf	votparquet-telecon-2024-11-05.pdf	r1	manage	139.5 K	2024-11-05 - 22:37	MarkTaylor
Topic revision: r16 - 2025-04-04 - MarkTaylor
IVOA
Log in or Register
IVOA.net
Wiki Home
WebChanges
WebTopicList
WebStatistics
Twiki Meta & Help
IVOA
Know
Main
Sandbox
TWiki
TWiki intro
TWiki tutorial
User registration
Notify me
Working Groups
Interest Groups
Time Domain
Committees
Stds&Procs
www.ivoa.net
Documents
Events
Members
XML Schema