[spark]Support change default database

[hddong]

Purpose

Linked issue: close #2627

Sometimes default can't be accessed, we need support change default database.

Tests

Add testChangeDefaultDbWithHive

API and Format

No

Documentation

No

[YannByron]

When default database can't be accessed?

[hddong]

When default database can't be accessed?

Hive with ranger, we usually restrict tenant access to the default database. When default database can't be accessed, paimon throws permission exception.

[JingsongLi]

Flink also has default database.

[YannByron]

Flink also has default database.

You mean that paimon can support to specify an other database as a default one when session starts up? @JingsongLi

In the case that the default database is limited to access by range, users should change database when submit sql in hive/spark-sql. And spark thrift-server throws exception if no database is provided in beeline cmd. IMO, it's reasonable.

[JingsongLi]

re-open to trigger test.

[JingsongLi]

@hddong You can show your exception. Describe your problem.

[YannByron]

@hddong what's the behavior if the default dataset you provided is not exist.

[JingsongLi]

close inactive pr.