RClickhouse icon indicating copy to clipboard operation
RClickhouse copied to clipboard

R crashes when reading nested data

Open alanpaulkwan opened this issue 3 years ago • 5 comments
trafficstars

I can provide (confidentially) a sample of data that is originated from a Parquet dataset that had very complicted nesting.

alanpaulkwan avatar Jun 17 '22 03:06 alanpaulkwan

Thanks, that would be helpful to understand your problem. Could you even reduce it to a minimal subset of observations?

inkrement avatar Jun 17 '22 06:06 inkrement

I didn't see your reply. If you want I could PM you credentials to one of my public clickhouse servers

Basically I discovered this trying to read Open Street Maps which has super nested data.

myclickhousewrapper("select * from osm.planet_history limit 1")

*** caught segfault *** address (nil), cause 'memory not mapped'

Traceback: 1: select(conn@ptr, statement) 2: dbSendQuery(conn, statement, ...) 3: dbSendQuery(conn, statement, ...) 4: .local(conn, statement, ...) 5: dbGetQuery(con, q2, ...) 6: dbGetQuery(con, q2, ...) 7: queryClickhouseDb(q = q, fix = fix, con_fn = getConClickhouseServer3, ...) 8: queryClickhouseServer3("select * from osm.planet_history limit 1")

Possible actions: 1: abort (with core dump, if enabled) 2: normal R exit 3: exit R without saving workspace 4: exit R saving workspace Selection:

alanpaulkwan avatar Oct 31 '22 09:10 alanpaulkwan

Due to time constraints, we cannot provide free private support. Please provide a minimal example that demonstrates the issue. If your source is Open Street Maps, there should not be any license issues, right?

inkrement avatar Oct 31 '22 10:10 inkrement

I understand, I was just trying to produce a replicable example by showing you a live database. I thought that was the easiest method.

What format of replicable example would you want? The underlying data, a schema, and a command to parse the file in?

alanpaulkwan avatar Oct 31 '22 10:10 alanpaulkwan

If your problem is related to parquet, please provide a minimal Parquet file.

inkrement avatar Oct 31 '22 10:10 inkrement