This vote passes with 6 binding and 3 non-binding +1 votes. I will update the PR[1] from draft to "ready for review". Thanks for bearing with all the votes :)
[1] https://github.com/apache/arrow/pull/10629 On Fri, Jul 2, 2021 at 1:40 AM Kazuaki Ishizaki <ishiz...@jp.ibm.com> wrote: > > +1 > > Kazuaki Ishizaki > > "Weston Pace" <weston.p...@gmail.com> wrote on 2021/06/30 18:52:46: > > > From: "Weston Pace" <weston.p...@gmail.com> > > To: dev@arrow.apache.org > > Date: 2021/06/30 18:53 > > Subject: [EXTERNAL] [VOTE] Arrow should state a convention for > > encoding instants as Timestamp with "UTC" as the time zone > > > > This vote is a result of previous discussion[1][2]. This vote is also > > a prerequisite for the PR in [5]. > > > > --- > > Some date & time libraries have three temporal concepts. For the sake > > of this document we will call them LocalDateTime, ZonedDateTime, and > > Instant. An Instant is a timestamp that has no meaningful reference > > time zone (e.g. events that did not occur on Earth or columns of > > timestamps spanning more than one time zone). For more extensive > > definitions and a discussion of their semantics and uses see [3]. > > Currently Arrow describes how to encode two of these three concepts > > into a Timestamp column and there is no guideline on how to store an > > Instant. > > > > > > This proposal states that Arrow should recommend that instants be > encoded > > into timestamp columns by setting the timezone string to "UTC". > > --- > > > > For sample arguments (currently grouped as "for changing schema.fbs" > > and "against changing schema.fbs") see [4]. For a detailed definition > > of the terms LocalDateTime, ZonedDateTime, and Instant and a > > discussion of their semantics see [3]. For a straw poll on > > possible ways to handle instants see [2]. > > > > This vote will be open for at least 72 hours. > > > > [ ] +1 Update schema.fbs to state the above convention > > [ ] +0 > > [ ] -1 Do not make any change > > > > [1] INVALID URI REMOVED > > > u=https-3A__lists.apache.org_thread.html_r8216e5de3efd2935e3907ad9bd20ce07e430952f84de69b36337e5eb-2540-253Cdev.arrow.apache.org-253E&d=DwIBaQ&c=jf_iaSHvJObTbx- > > siA1ZOg&r=b70dG_9wpCdZSkBJahHYQ4IwKMdp2hQM29f- > > ZCGj9Pg&m=avV0JpLmaymMbxpZiYwNb9Yug7bj3PGiNYiJCM-x3kY&s=Ty-Oq- > > Gfuo2KRdogmjFFOLvji5yQ0LrrBZWWO7hDufs&e= > > [2] INVALID URI REMOVED > > > u=https-3A__lists.apache.org_thread.html_r1bdffc76537ae9c12c37396880087fee9c0eec9000bf6ed4c9850c44-2540-253Cdev.arrow.apache.org-253E&d=DwIBaQ&c=jf_iaSHvJObTbx- > > siA1ZOg&r=b70dG_9wpCdZSkBJahHYQ4IwKMdp2hQM29f- > > ZCGj9Pg&m=avV0JpLmaymMbxpZiYwNb9Yug7bj3PGiNYiJCM- > > x3kY&s=NyxlTSPly7kAqwMiuXS7BH0lZkK3W0VmVSvvRF-ANa8&e= > > [3] INVALID URI REMOVED > > > u=https-3A__docs.google.com_document_d_1QDwX4ypfNvESc2ywcT1ygaf2Y1R8SmkpifMV7gpJdBI_edit-3Fusp-3Dsharing&d=DwIBaQ&c=jf_iaSHvJObTbx- > > siA1ZOg&r=b70dG_9wpCdZSkBJahHYQ4IwKMdp2hQM29f- > > ZCGj9Pg&m=avV0JpLmaymMbxpZiYwNb9Yug7bj3PGiNYiJCM- > > x3kY&s=opFrDCQFvlSmY31hxs8MDKLcUe3muSTaNXosFCaPX5U&e= > > [4] INVALID URI REMOVED > > > u=https-3A__docs.google.com_document_d_1xEKRhs-2DGUSMwjMhgmQdnCNMXwZrA10226AcXRoP8g9E_edit-3Fusp-3Dsharing&d=DwIBaQ&c=jf_iaSHvJObTbx- > > siA1ZOg&r=b70dG_9wpCdZSkBJahHYQ4IwKMdp2hQM29f- > > ZCGj9Pg&m=avV0JpLmaymMbxpZiYwNb9Yug7bj3PGiNYiJCM- > > x3kY&s=fIjWMI0tuH57ffsGzpOX85d5Dd7TN4tT_h0cj1elNbw&e= > > [5] INVALID URI REMOVED > > > u=https-3A__github.com_apache_arrow_pull_10629&d=DwIBaQ&c=jf_iaSHvJObTbx- > > siA1ZOg&r=b70dG_9wpCdZSkBJahHYQ4IwKMdp2hQM29f- > > ZCGj9Pg&m=avV0JpLmaymMbxpZiYwNb9Yug7bj3PGiNYiJCM- > > x3kY&s=RQrwm8rHhpbx-6JbTZ4WMVpWGrUIu7Ns7oGrfLMk2uQ&e= > >