New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
[ERROR] Numeric columns do not support multivalue rows #7086
Comments
Things which i have tried out.
"fields": [
{
"type": "path",
"name": "edata_visits_index",
"expr": "$.edata.visits[0].index"
}
]
But If i try to index all visits value as long data type format then it will throw Any work around to index all visits value as long/integer format ? |
@manjudr, it is true, numeric columns do not support multivalue rows at this time. Probably storing them as strings is your best bet, or alternatively, taking up the effort to propose and drive multivalue numeric column support. |
@gianm Thanks for your reply. We tried using a transformation on the multi-valued field and convert it to numeric values. |
@gianm "transformSpec": {
"transforms": [
{
"type": "expression",
"name": "edata_visits_index",
"expression": "cast(edata_visits_index,'LONG')"
}
]
} Output: [
{
"segmentId": "datasource-events-33_2019-11-07T00:00:00.000Z_2019-11-08T00:00:00.000Z_2019-02-26T07:42:38.349Z",
"columns": [
"edata_visits_index"
],
"events": [
{
"__time": 1573146630927,
"edata_visits_index": "0"
}
]
}
] Any other alternative solution to convert the |
This issue has been marked as stale due to 280 days of inactivity. It will be closed in 4 weeks if no further activity occurs. If this issue is still relevant, please simply write any comment. Even if closed, you can still revive the issue at any time or discuss it on the dev@druid.apache.org list. Thank you for your contributions. |
This issue has been closed due to lack of activity. If you think that is incorrect, or the issue requires additional review, you can revive the issue at any time. |
Fails to ingest the nested object value into druid using kafka with below ingestion spec and test input data.
Sample Input data :
kafka Ingestion spec
Error Output
Is something wrong with my ingestion spec ? why we are getting this error ?
The text was updated successfully, but these errors were encountered: