knime
Knime MongoDBReader read an Object with an array in it
I tried to read an Object with the MongoDB reader and I always get the following error message:
"ERROR MongoDB Reader 0:19 Execute failed: Invalid type 19 for field value".
The typ of the field value is an Array. I want to read the object and want to get the array inside the Object.
Here you can see the MongoDB with the Object I want to read.
Solution
“Type 19” indicates a Decimal128 type, see this link.
I’d assume that this type is just not supported by the MongoDB nodes (note how above link says “New in version 3.4.”).
[personal opinion] The KNIME MongoDB nodes are not very well maintained. Beside some basic “hello world” attempts I wasn’t able to use them for any of my real-world usage scenarios.
- Question using XPath to look for a sibling of a td with a certain name
- KNIME: How to add numbers on two matching columns
- Extract Student number
- Knime Excel file size issue when saving
- Pandas Dataframe (Object) - Count occurrence of values and and group in columns
- Starting KNIME from console: NoClassDefFoundError: Could not initialize class org.knime.database.driver.DBDriverRegistry$DriverClassLoader
- Using Mac Automator to run a Knime Workflow
- How to extract sql code from Knime Nodes?
- "An illegal attempt was made to upload a document" when passing a url in a FormEncodedHTTPEntityCreator
- Upload a file using the post node in Knime
- Regex to remove duplicate numbers from a string
- Knime windows scheduler task without server
- Remove part of a string in each row of a large column of data in KNIME
- How to convert a table in a matrix in KNIME?
- Postgres copy table schema is_null constraints not included
- Knime Sumifs based on date range
- How to add values of 2 rows of a duplicate row in KNIME?
- KNIME Databricks community connection
- Regex with multiple groups, some of which are optional
- Knime BigData Local Environment & findspark
- Adding NULL value to row in KNIME
- Knime MongoDBReader read an Object with an array in it
- Conditional join of two tables in Knime
- Knime string replacer, replace everything until some special string
- I am trying to filter a database table with rows of .html files, but getting the error: TypeError: expected string or bytes-like object
- Write result of a loop into a table knime
- Knime loop to write csv file in different folder?
- Apply PMML predictor model in python
- Java Loop with condition inside
- Knime Install Extensions fails: HTTP Proxy Authentication Required