jieguolove
jieguolove
> Hi, The OS version isn't supposed to run a Immerse. It's just the DB. > > So if you want to useImmerse and the rest of web interface you...
There is another problem: A single large table query is very fast in milliseconds, but if two large tables are associated with the query, the speed is very slow.Is this...
The query was inconclusive for several minutes, so I Ctrl+c. `omnisky@omnisky-Super-Server:~$ $HEAVYAI_PATH/bin/heavysql -p HyperInteractive User admin connected to database heavyai heavysql> \timing heavysql> select count(*) from j1; EXPR$0 1778311840 1...
This discovery may be helpful to fix the bug of ora2pg: in oracle: select st_astext (shape) from jzsh_lsd_maint_unionbase_84 where enbid='15181' use the ST_GeomFromText function in the pg to convert this...
temp sloved: sed -i 's/SRID=;//g' *.sql sed -i 's/ nan/ -1.797693134862316e+308/g' *.sql
> Hi, thanks for the report. Can you provide me the value of GEOMETRY_EXPORT_TYPE in your ora2Pg.conf? There is no such parameter in my ora2Pg.conf
> Sorry, this is GEOMETRY_EXTRACT_TYPE same, There is no such parameter in my ora2Pg.conf
> data.conf： PG_VERSION 12 ORACLE_HOME /oracle/app/oracle/product/11.2.0/dbhome_1 ORACLE_DSN dbi:Oracle:host=192.168.1.100;sid=db;port=1521 ORACLE_USER test ORACLE_PWD password SCHEMA test PG_NUMERIC_TYPE 0 PG_INTEGER_TYPE 1 DEFAULT_NUMERIC float NLS_LANG AMERICAN_AMERICA.UTF8 export command: ora2pg -p -c data.conf -t COPY...
Got it，thanks a lot!
**I can only query normally after restarting heavydb. Is there a heavydb parameter to avoid this problem?** ` [root@test ~]# systemctl stop heavydb [root@test ~]# systemctl start heavydb [root@test ~]#...