[Bug] [Lineage] create table as select from Hive_table for lineage analysis

### Code of Conduct

- [x] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)

### Search before asking

- [x] I have searched in the [issues](https://github.com/apache/kyuubi/issues?q=is%3Aissue) and found no similar issues.

### Describe the bug

spark-sql (atlas_ybx)> create table table_lineage_1 as select * from raw_logs;
Time taken: 1.812 seconds

some execution result is:

But, I can't find the lineage to this table `table_lineage_1` from atlas web UI.

### Affects Version(s)

1.9.0

### Kyuubi Server Log Output

```logtalk

```

### Kyuubi Engine Log Output

```logtalk

```

### Kyuubi Server Configurations

```yaml

```

### Kyuubi Engine Configurations

```yaml

```

### Additional context

_No response_

### Are you willing to submit PR?

- [x] Yes. I would be willing to submit a PR with guidance from the Kyuubi community to fix.
- [x] No. I cannot submit a PR at this time.

Start by reproducing the reported `CREATE TABLE ... AS SELECT` in Spark SQL against a Hive table, then inspect Kyuubi's lineage integration and its Atlas reporting path. The issue names no source files or tests, so first locate existing lineage tests for CTAS and Hive sources. Done means the resulting table's lineage appears in the Atlas web UI.

Written by the indexing model from the issue text.