Hi, Alessandro Thanks for your response.
I have implemented my feature by manually creating a schema. But I can't run the schematool because I want to use the new schema in the unit test that belongs to another project. In the unit test, I use hadoop-mini-clusters-hivemetastore to initialize my local hive metastore. There should be a script or code for initializing the derby database in hive metastore, and I miss it. Would anyone know about it? On Wed, 30 Nov 2022 at 18:03, Alessandro Solimando < alessandro.solima...@gmail.com> wrote: > Hi Jiajun, > how are you running the schematool? > > "schematool -verbose -dbType derby -initSchema" <-- are you maybe missing > the "-initSchema" bit? > > Can you provide the exact list of commands you are using? > > I am not very familiar with Hive 1.x, but maybe we can get it working. > > Best regards, > Alessandro > > On Wed, 30 Nov 2022 at 09:23, Jiajun Xie <jiajunbernou...@gmail.com> > wrote: > > > Hello~ > > I need to create a new table in the metastore. > > > > I tried to update `metastore/src/model/package.jdo` and > > `metastore/scripts/upgrade/derby/hive-schema-1.2.0.derby.sql`. (My > feature > > is based on branch-1.2) > > Then I set > > `datanucleus.schema.autoCreateTables`, > > `datanucleus.schema.generateDatabase.createScript`. > > None of them work. > > > > How to create a new table when automatically generating schema? Thank you > > very much. > > >