search

heavyai / heavydb

HeavyDB (formerly OmniSciDB)
https://heavy.ai
Apache License 2.0
2.93k stars 445 forks source link

Support for converting geo column to string #785

Open anirudh-here-com opened 1 year ago

anirudh-here-com commented 1 year ago

Something like ST_AsText function which will return a string representation of a geo column

pearu commented 1 year ago

FYI, https://github.com/heavyai/heavydb-internal/pull/7315 introduces ST_AsText and ST_AsBinary. So, the issue should be resolved in the next heavydb release.

anirudh-here-com commented 1 year ago

Thanks for the reply!

For some reason I’m unable to access the link.. Which brings another question, are we gonna get this in the open source heavy db repo? We're using the heavydb only without rendering engine🙂

Get Outlook for iOShttps://aka.ms/o0ukef

From: Pearu Peterson @.> Sent: Friday, June 9, 2023 3:42:02 PM To: heavyai/heavydb @.> Cc: Simha, Anirudh @.>; Author @.> Subject: [EXTERNAL] Re: [heavyai/heavydb] Support for converting geo column to string (Issue #785)

FYI, heavyai/heavydb-internal#7315https://github.com/heavyai/heavydb-internal/pull/7315 introduces ST_AsText and ST_AsBinary. So, the issue should be resolved in the next heavydb release.

— Reply to this email directly, view it on GitHubhttps://github.com/heavyai/heavydb/issues/785#issuecomment-1584328890, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AV6TJRKLEWTD55T55RDL6XDXKLZHFANCNFSM6AAAAAAZAKMMGA. You are receiving this because you authored the thread.Message ID: @.***>

LEARN FAST: This email originated outside of HERE. Please do not click on links or open attachments unless you recognize the sender and know the content is safe. Thank you.

cdessanti commented 1 year ago

Hi,

Yes you can't see the URL, because it's of our internal repository, and this PR isn't landed yet into any release of the product, nor the OS version you are using.

I'll come back in this thread when the function will be available in a release; it'0s likely to be released in FREE/EE and the in OS.

cdessanti commented 1 year ago

A little crazy idea. With a copy command you can export a csv file containing the WTKs and re-read them in the db using the CSV as source.

What are you going to use those WKTs?

anirudh-here-com commented 1 year ago

I want to access geo columns through select_ipc_gpu(arrow transfer) for some downstream processing. The queries will be in high frequency

Get Outlook for iOShttps://aka.ms/o0ukef

From: Candido Dessanti @.> Sent: Friday, June 9, 2023 8:11:56 PM To: heavyai/heavydb @.> Cc: Simha, Anirudh @.>; Author @.> Subject: [EXTERNAL] Re: [heavyai/heavydb] Support for converting geo column to string (Issue #785)

A little crazy idea. With a copy command you can export a csv file containing the WTKs and re-read them in the db using the CSV as source.

What are you going to use those WKTs?

— Reply to this email directly, view it on GitHubhttps://github.com/heavyai/heavydb/issues/785#issuecomment-1584697841, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AV6TJRIHZHRRMGJQSQLM373XKMY3JANCNFSM6AAAAAAZAKMMGA. You are receiving this because you authored the thread.Message ID: @.***>

LEARN FAST: This email originated outside of HERE. Please do not click on links or open attachments unless you recognize the sender and know the content is safe. Thank you.