如何将数据从现有数据复制到hana中的另一个结构化表

时间:2022-12-02 16:51:42

I tried to insert data to a new table from an existing table in hana and I used

我试图从hana中的现有表中插入数据到新表,我使用过

INSERT INTO "SCHEMA"."NEW_TABLE" SELECT * FROM   "SCHEMA"."OLD_TABLE"

the query was executing but in the end it showed lost data connectivity.Now I cannot login to the HANA as the USER which I was using.Was my query wrong?Could anyone clarify me.Any help is appreciated.

查询正在执行,但最后它显示丢失的数据连接。现在我无法以我正在使用的用户身份登录HANA。我的查询错了吗?任何人都可以澄清我。任何帮助都表示赞赏。

1 个解决方案

#1


2  

Your login issues have nothing to do with your INSERT command. If the system is still reachable e.g. with a admin user you may want to check the indexserver trace files to find out the reason for the connection loss.

您的登录问题与INSERT命令无关。如果系统仍然可以到达,例如对于管理员用户,您可能需要检查indexserver跟踪文件以找出连接丢失的原因。

#1


2  

Your login issues have nothing to do with your INSERT command. If the system is still reachable e.g. with a admin user you may want to check the indexserver trace files to find out the reason for the connection loss.

您的登录问题与INSERT命令无关。如果系统仍然可以到达,例如对于管理员用户,您可能需要检查indexserver跟踪文件以找出连接丢失的原因。