Hi Simhadri, Zsolt
Thank you for checking.
This release is built on top of Hive 4.0.0, it doesn't change schema, so
"4.0.1" is equivalent to "4.0.0", there is no specific schema version for 4.0.1.
I also checked some releases: 3.1.1, 3.1.2, 3.1.3, they are released from 3.1.0
and sharing the same hive-schema-3.1.0.{db}.sql, I think we don't want to
introduce schema changes to those released from the same branch.
If a user specify the version via "-initSchemaTo", make sure the
hive-schema-{version}.{db}.sql reside under the script directory, the user can
use either '-initSchema' or '-initOrUpgradeSchema' to initialize or upgrade the
schema to this 4.0.1 version.
Best,
Zhihua
On 2024/09/26 11:18:06 Zsolt Miskolczi wrote:
> Hi, not only this, all the schema scripts are missing for 4.0.1. On the
> other hand, there are scripts prepared to 4.1.0
> So I think it is a task to do before the release
> [image: image.png]
> [image: image.png]
>
>
> Simhadri G <simhad...@apache.org> ezt írta (időpont: 2024. szept. 26., Cs,
> 13:07):
>
> > Thanks Zhihua for driving the release.
> >
> > I was trying to set up hive schema using the schema tool with the
> > following command,
> > but schema tool seems to be failing for MySQL.
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > *root@localhost:/# hive/bin/schematool -userName hive -passWord 'hive'
> > -dbType mysql -initSchemaTo 4.0.1SLF4J: Class path contains multiple SLF4J
> > bindings.SLF4J: Found binding in
> > [jar:file:/apache-hive-4.0.1-bin/lib/log4j-slf4j-impl-2.18.0.jar!/org/slf4j/impl/StaticLoggerBinder.class]SLF4J:
> > Found binding in
> > [jar:file:/apache-tez-0.10.3-bin/lib/slf4j-reload4j-1.7.36.jar!/org/slf4j/impl/StaticLoggerBinder.class]SLF4J:
> > Found binding in
> > [jar:file:/hadoop-3.3.6/share/hadoop/common/lib/slf4j-reload4j-1.7.36.jar!/org/slf4j/impl/StaticLoggerBinder.class]SLF4J:
> > See http://www.slf4j.org/codes.html#multiple_bindings
> > <http://www.slf4j.org/codes.html#multiple_bindings> for an
> > explanation.SLF4J: Actual binding is of type
> > [org.apache.logging.slf4j.Log4jLoggerFactory]Metastore connection URL:
> > jdbc:mysql://localhost/metastore?createDatabaseIfNotExist=trueMetastore
> > connection Driver : com.mysql.jdbc.DriverMetastore connection User:
> > hiveStarting metastore schema initialization to 4.0.1Unknown version
> > specified for initialization: 4.0.1Underlying cause:
> > java.nio.file.NoSuchFileException :
> > /hive/scripts/metastore/upgrade/mysql/hive-schema-4.0.1.mysql.sqlUse
> > --verbose for detailed stacktrace.*** schemaTool failed ****
> >
> >
> > The same command used to work for earlier versions.
> > Please let me know if I am missing something.
> >
> > Thanks!
> > Simhadri G
> >
> > On Thu, Sep 26, 2024 at 3:58 PM Zhihua Deng <den...@apache.org> wrote:
> >
> >> Hi Everyone,
> >>
> >> We would like to thank everyone who has contributed to the project and
> >> request
> >> the Hive PMC members to review and vote on this new release candidate.
> >>
> >> Apache Hive 4.0.1 Release Candidate 0 is available here:
> >> https://dist.apache.org/repos/dist/dev/hive/hive-4.0.1/
> >>
> >> The checksums are these:
> >> - 2bf988a1ed17437b1103e367939c25a13f64d36cf6d1c3bef8c3f319f0067619
> >> apache-hive-4.0.1-bin.tar.gz
> >> - 8df66c289bc8a38b0d13bb59aa7aec678b9fad98a6c03deedef1eb8fbfbd9c39
> >> apache-hive-4.0.1-src.tar.gz
> >>
> >> You can find the KEYS file here:
> >> https://downloads.apache.org/hive/KEYS
> >>
> >> Maven artifacts are available here:
> >> https://repository.apache.org/content/repositories/orgapachehive-1135/
> >>
> >> The tag release-4.0.1-rc0 has been applied to the source for this release
> >> in github, you can see it at
> >> https://github.com/apache/hive/tree/release-4.0.1-rc0
> >>
> >> The git commit hash is:
> >>
> >> https://github.com/apache/hive/commit/3af4517eb8cfd9407ad34ed78a0b48b57dfaa264
> >>
> >> The vote is open for the next 72 hours and passes if a majority of at
> >> least
> >> three +1 PMC votes are cast.
> >>
> >> (Only PMC members have binding votes, however, other community members
> >> are encouraged to cast non-binding votes.)
> >>
> >>
> >> [ ] +1 Release this package as Apache Hive 4.0.1
> >> [ ] +0
> >> [ ] -1 Do not release this because...
> >>
> >> Please download, verify, and test.
> >>
> >> Thanks,
> >> Zhihua
> >>
> >
>
