You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
ALTERTABLE test MODIFY COLUMN json JSON(a.b UInt32, a.c String);
How about this:
ALTERTABLE test MODIFY COLUMN json JSON(a.b String);
Or this:
ALTERTABLE test MODIFY COLUMN json JSON(a.c String);
What exactly is the behavior? Does the type hint influence query time, or ingest time, or both? What happens to the existing data when modifying the type? I'm ingesting JSON data with a schema that can change over time and I want to provide as much type hints as possible.
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
Uh oh!
There was an error while loading. Please reload this page.
Uh oh!
There was an error while loading. Please reload this page.
-
Hi, I have a question about how the JSON type with hints works exactly. If I have something like this:
can I then safely do something like this:
How about this:
Or this:
What exactly is the behavior? Does the type hint influence query time, or ingest time, or both? What happens to the existing data when modifying the type? I'm ingesting JSON data with a schema that can change over time and I want to provide as much type hints as possible.
Beta Was this translation helpful? Give feedback.
All reactions