LemonLiTree opened a new pull request, #18999:
URL: https://github.com/apache/doris/pull/18999

   Support geometry type, Geometry data is stored in wkb(Well-known_binary) 
format
   mysql> create table geo_test
       -> (
       ->     id int,
       ->     geodata geometry
       -> )
       -> DUPLICATE KEY(`id`)  
       -> DISTRIBUTED BY HASH(id)
       -> PROPERTIES
       -> (
       ->     "replication_num" = "1"
       -> );
   Query OK, 0 rows affected (0.05 sec)
   
   mysql> insert into geo_test values (1,"POINT(1 1)");
   Query OK, 1 row affected (0.05 sec)
   {'label':'insert_21d0dd0e85dc4f74_9fbe459c06aaedbd', 'status':'VISIBLE', 
'txnId':'15024'}
   
   mysql> select * from geo_test;
   +------+--------------------------------------------+
   | id   | geodata                                    |
   +------+--------------------------------------------+
   |    1 | 0101000000000000000000f03f000000000000f03f |
   +------+--------------------------------------------+
   1 row in set (0.04 sec)


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org

Reply via email to