# \#big-data **URL:** https://forum.knime.com/tag/big-data/137.md [Latest](https://forum.knime.com/latest.md) · [Categories](https://forum.knime.com/categories.md) · [Tags](https://forum.knime.com/tags.md) --- ## [Since KNIME version 5.4.3 and later, we have been encountering an issue when using the HDFS](https://forum.knime.com/t/since-knime-version-5-4-3-and-later-we-have-been-encountering-an-issue-when-using-the-hdfs/91209)
**Author:** [@geonjukim](https://forum.knime.com/u/geonjukim)\ **Replies:** 3\ **Last updated:** [April 9, 2026, 9:02am UTC](https://forum.knime.com/t/since-knime-version-5-4-3-and-later-we-have-been-encountering-an-issue-when-using-the-hdfs/91209 "2026-04-09T09:02:42Z")
Hi KNIME Team, Since KNIME version 5.4.3 and later, we have been encountering an issue when using the HDFS Connector. The following error occurs consistently during execution: No FileSystem for scheme “hdfs” We hav… --- ## [Snowflake - JDBC error for long running query](https://forum.knime.com/t/snowflake-jdbc-error-for-long-running-query/91689)
**Author:** [@ChrisRB](https://forum.knime.com/u/ChrisRB)\ **Replies:** 5\ **Last updated:** [March 31, 2026, 10:14am UTC](https://forum.knime.com/t/snowflake-jdbc-error-for-long-running-query/91689 "2026-03-31T10:14:16Z")
Dear experts, I have an issue with a long running on Snowflake via Knime. I can connect without problems and query Snowflake but if the query runs approx. more than 5 minutes, I receive an error: Execute failed: JDBC … --- ## [Automation with KNIME or n8n](https://forum.knime.com/t/automation-with-knime-or-n8n/91302)
**Author:** [@VAGR\_ISK](https://forum.knime.com/u/VAGR_ISK)\ **Replies:** 8\ **Last updated:** [February 18, 2026, 9:11am UTC](https://forum.knime.com/t/automation-with-knime-or-n8n/91302 "2026-02-18T09:11:52Z")
Hi Knimers, I recently created a video comparing KNIME and n8n for automation tasks, and wanted to share it with you all. In this video, I demonstrate: How to approach similar automation scenarios in both platforms K… --- ## [Get Day of week](https://forum.knime.com/t/get-day-of-week/91433)
**Author:** [@eduardoam](https://forum.knime.com/u/eduardoam)\ **Replies:** 2\ **Last updated:** [February 16, 2026, 4:05pm UTC](https://forum.knime.com/t/get-day-of-week/91433 "2026-02-16T16:05:02Z")
Hi team, Could someone help me with a formula to get the day of the week? Thanks! Eduardo --- ## [How to Limit CPU Core Usage per Job in KNIME Hub?](https://forum.knime.com/t/how-to-limit-cpu-core-usage-per-job-in-knime-hub/91201)
**Author:** [@JaeHwanChoi](https://forum.knime.com/u/JaeHwanChoi)\ **Replies:** 2\ **Last updated:** [January 22, 2026, 9:02am UTC](https://forum.knime.com/t/how-to-limit-cpu-core-usage-per-job-in-knime-hub/91201 "2026-01-22T09:02:48Z")
Hello KNIME Support Team, I have a question regarding resource management on KNIME Hub. We are currently running ML-related workflows on a KNIME Hub with 8 CPU cores available. When a workflow is executed, it quickly c… --- ## [How Does KNIME Handle Real-Time Data When Using Kafka Nodes?](https://forum.knime.com/t/how-does-knime-handle-real-time-data-when-using-kafka-nodes/91200)
**Author:** [@JaeHwanChoi](https://forum.knime.com/u/JaeHwanChoi)\ **Replies:** 1\ **Last updated:** [January 22, 2026, 7:01am UTC](https://forum.knime.com/t/how-does-knime-handle-real-time-data-when-using-kafka-nodes/91200 "2026-01-22T07:01:49Z")
Hello KNIME Team and Community, I have a question regarding the use of Kafka-related nodes in KNIME, from both a user and an operator perspective. As far as I understand, KNIME provides nodes that can connect to Kafka.… --- ## [Difference Between KNIME Native ML Nodes and H2O ML Nodes](https://forum.knime.com/t/difference-between-knime-native-ml-nodes-and-h2o-ml-nodes/91163)
**Author:** [@JaeHwanChoi](https://forum.knime.com/u/JaeHwanChoi)\ **Replies:** 6\ **Last updated:** [January 9, 2026, 6:51am UTC](https://forum.knime.com/t/difference-between-knime-native-ml-nodes-and-h2o-ml-nodes/91163 "2026-01-09T06:51:52Z")
Hello everyone, I have a question about the difference between KNIME native ML nodes and H2O ML nodes. It is often said that native ML nodes are more row-based, while H2O ML nodes use a columnar processing model. Do… --- ## [Search within text within a cell](https://forum.knime.com/t/search-within-text-within-a-cell/91094)
**Author:** [@alex1368](https://forum.knime.com/u/alex1368)\ **Replies:** 7\ **Last updated:** [January 8, 2026, 12:11pm UTC](https://forum.knime.com/t/search-within-text-within-a-cell/91094 "2026-01-08T12:11:29Z")
I have a table and I want to search within a column and I want my search to be such that if I enter part of the content, it will show me every cell that contains that value I entered For example, if my phone number was … --- ## [Variable Clustering Usage](https://forum.knime.com/t/variable-clustering-usage/91148)
**Author:** [@JaeHwanChoi](https://forum.knime.com/u/JaeHwanChoi)\ **Replies:** 3\ **Last updated:** [January 7, 2026, 8:43am UTC](https://forum.knime.com/t/variable-clustering-usage/91148 "2026-01-07T08:43:12Z")
Hello, KNIME Community, I would like to perform variable clustering in KNIME. Instead of clustering observations (rows), my goal is to cluster variables (columns). For example, when working with a dataset containing a… --- ## [Separating Excel files (empty files from files with content)](https://forum.knime.com/t/separating-excel-files-empty-files-from-files-with-content/91089)
**Author:** [@alex1368](https://forum.knime.com/u/alex1368)\ **Replies:** 5\ **Last updated:** [December 28, 2025, 6:55pm UTC](https://forum.knime.com/t/separating-excel-files-empty-files-from-files-with-content/91089 "2025-12-28T18:55:01Z")
Hello I have a large number of Excel files in a folder that I want to use after ETL, but some of the Excel files only have one row. I want the system to automatically delete Excel files that have one row and send Excel … --- ## [KNIME workflow to create RDKit synthon space from SMILES building blocks?](https://forum.knime.com/t/knime-workflow-to-create-rdkit-synthon-space-from-smiles-building-blocks/89658)
**Author:** [@Knimeraja](https://forum.knime.com/u/Knimeraja)\ **Replies:** 10\ **Last updated:** [December 16, 2025, 5:04am UTC](https://forum.knime.com/t/knime-workflow-to-create-rdkit-synthon-space-from-smiles-building-blocks/89658 "2025-12-16T05:04:36Z")
Title: KNIME workflow to create RDKit synthon space from SMILES building blocks? Hi all, I am reposting this as my earlier post was deleted by me by mistake. I’m looking for a KNIME workflow that takes a set of buildin… --- ## [How to practically use the MCP Server example workflow from KNIME Hub?](https://forum.knime.com/t/how-to-practically-use-the-mcp-server-example-workflow-from-knime-hub/90531)
**Author:** [@lca50666](https://forum.knime.com/u/lca50666)\ **Replies:** 2\ **Last updated:** [December 3, 2025, 7:39am UTC](https://forum.knime.com/t/how-to-practically-use-the-mcp-server-example-workflow-from-knime-hub/90531 "2025-12-03T07:39:30Z")
Hi everyone, I’m trying to understand how to practically use the MCP Server workflow from KNIME Hub: :backhand\_index\_pointing\_right: MCP Server example on Hub I’ve read through the flow and I think I roughly understa… --- ## [method request for big data](https://forum.knime.com/t/method-request-for-big-data/90823)
**Author:** [@msg90](https://forum.knime.com/u/msg90)\ **Replies:** 7\ **Last updated:** [December 1, 2025, 5:27am UTC](https://forum.knime.com/t/method-request-for-big-data/90823 "2025-12-01T05:27:14Z")
Hello, I’m trying to compile some data but haven’t been able to. I’d appreciate any help or suggestions on methods. I have three tables. The first table has 4,000 entries, and the other two tables have 1 million entries… --- ## [knime-5-5-chromium-crashing](https://forum.knime.com/t/knime-5-5-chromium-crashing/90662)
**Author:** [@Amit\_Mohanty](https://forum.knime.com/u/Amit_Mohanty)\ **Replies:** 1\ **Last updated:** [November 18, 2025, 2:09pm UTC](https://forum.knime.com/t/knime-5-5-chromium-crashing/90662 "2025-11-18T14:09:30Z")
i saw that 5.5.2 fixed it but I am still getting this error. interestingly it doesn’t happen always but still very frequently. --- ## [Python Script in KNIME doesn’t recognize float values correctly - comparisons return wrong results](https://forum.knime.com/t/python-script-in-knime-doesn-t-recognize-float-values-correctly-comparisons-return-wrong-results/90335)
**Author:** [@phil21oo](https://forum.knime.com/u/phil21oo)\ **Replies:** 3\ **Last updated:** [October 29, 2025, 6:44am UTC](https://forum.knime.com/t/python-script-in-knime-doesn-t-recognize-float-values-correctly-comparisons-return-wrong-results/90335 "2025-10-29T06:44:10Z")
Hi everyone, I’m using a Python Script node in KNIME to calculate a custom score based on a numeric column called organic\_etv. The column appears as Number (Float) in KNIME, and the values look like this in the table p… --- ## [Spark Date Type Issue](https://forum.knime.com/t/spark-date-type-issue/90247)
**Author:** [@JaeHwanChoi](https://forum.knime.com/u/JaeHwanChoi)\ **Replies:** 6\ **Last updated:** [October 22, 2025, 2:17am UTC](https://forum.knime.com/t/spark-date-type-issue/90247 "2025-10-22T02:17:08Z")
Hello KNIME Support Team, I have a question regarding Spark Date types. When I retrieve data using now(), the result appears in an unusual format rather than in yyyymmdd or similar. Even if I try to specify the type w… --- ## [BIRT 404 error](https://forum.knime.com/t/birt-404-error/90225)
**Author:** [@Pawelec\_G](https://forum.knime.com/u/Pawelec_G)\ **Replies:** 1\ **Last updated:** [October 17, 2025, 1:31pm UTC](https://forum.knime.com/t/birt-404-error/90225 "2025-10-17T13:31:55Z")
Hello, I have installed KNIME Report Designer BIRT. I used a workflow from here to see how it works Basic example of reporting with BIRT – KNIME Community Hub The problem is that when I click on “View report,” I get “H… --- ## [Default Credential Provider does not work with Amazon Athena Connector](https://forum.knime.com/t/default-credential-provider-does-not-work-with-amazon-athena-connector/89375)
**Author:** [@MikePAM](https://forum.knime.com/u/MikePAM)\ **Replies:** 1\ **Last updated:** [August 29, 2025, 8:16pm UTC](https://forum.knime.com/t/default-credential-provider-does-not-work-with-amazon-athena-connector/89375 "2025-08-29T20:16:55Z")
When configuring my amazon authenticator to use default credential provider chain, my amazon athena connector node errors I’ve checked with my team and they are all having the same issue. How do we resolve this? --- ## [HTML File to be read on EXcel reader?](https://forum.knime.com/t/html-file-to-be-read-on-excel-reader/89481)
**Author:** [@RamyHussein](https://forum.knime.com/u/RamyHussein)\ **Replies:** 4\ **Last updated:** [August 7, 2025, 4:09pm UTC](https://forum.knime.com/t/html-file-to-be-read-on-excel-reader/89481 "2025-08-07T16:09:15Z")
Dears I am trying to read the attached file usking KNIME, Can any one help in this, it is like HTML table, automatically generated like this, which nodes i should use to read it as table ! 20250806\_10\_30\_21PM\_Export.x… --- ## [Knime 5.5 Chromium Crashing](https://forum.knime.com/t/knime-5-5-chromium-crashing/89238)
**Author:** [@Sarah\_rushton](https://forum.knime.com/u/Sarah_rushton)\ **Replies:** 1\ **Last updated:** [July 31, 2025, 8:17pm UTC](https://forum.knime.com/t/knime-5-5-chromium-crashing/89238 "2025-07-31T20:17:16Z")
Hello, We use knime for a number of scheduled workflows from ETL’s to report automation. This has worked perfectly, running multiple workflows at the same time on the same workspace via .bat files. However, we ungraded … --- ## [Near Real Time Business Intelligence](https://forum.knime.com/t/near-real-time-business-intelligence/89074)
**Author:** [@Marc\_Goossens](https://forum.knime.com/u/Marc_Goossens)\ **Replies:** 5\ **Last updated:** [July 13, 2025, 10:18am UTC](https://forum.knime.com/t/near-real-time-business-intelligence/89074 "2025-07-13T10:18:05Z")
Hi all, I have created a new topic on my site about Near Real Time BI. Here is the link , I hope you find it useful… --- ## [Data Warehousing - Cascading prompts](https://forum.knime.com/t/data-warehousing-cascading-prompts/88904)
**Author:** [@Marc\_Goossens](https://forum.knime.com/u/Marc_Goossens)\ **Replies:** 2\ **Last updated:** [July 2, 2025, 9:09am UTC](https://forum.knime.com/t/data-warehousing-cascading-prompts/88904 "2025-07-02T09:09:43Z")
Hi everybody, I have added a topic about Cascading Prompts to my web. Have a nice day! In case you are interested, here is the link: --- ## [Data Warehouse as a Service product](https://forum.knime.com/t/data-warehouse-as-a-service-product/88862)
**Author:** [@Marc\_Goossens](https://forum.knime.com/u/Marc_Goossens)\ **Replies:** 0\ **Last updated:** [June 30, 2025, 9:40am UTC](https://forum.knime.com/t/data-warehouse-as-a-service-product/88862 "2025-06-30T09:40:08Z")
Hello all, I have added some screenshots of practical examples of our Data Warehouse as a Service offering. Here goes the link : As always, looking forward to your feedback. --- ## [Data Warehouse - Summary tables](https://forum.knime.com/t/data-warehouse-summary-tables/88856)
**Author:** [@Marc\_Goossens](https://forum.knime.com/u/Marc_Goossens)\ **Replies:** 0\ **Last updated:** [June 29, 2025, 8:43am UTC](https://forum.knime.com/t/data-warehouse-summary-tables/88856 "2025-06-29T08:43:16Z")
Good Morning. I have added a new topic to my web on Data Warehousing with KNIME about Summary (or Aggregate) tables. As always, comments are welcome. Here is the link --- ## [Issues Reading .parquet and .orc Files from Shared Folders on Intranet with Knime](https://forum.knime.com/t/issues-reading-parquet-and-orc-files-from-shared-folders-on-intranet-with-knime/87870)
**Author:** [@JonathanF14](https://forum.knime.com/u/JonathanF14)\ **Replies:** 4\ **Last updated:** [May 16, 2025, 3:12am UTC](https://forum.knime.com/t/issues-reading-parquet-and-orc-files-from-shared-folders-on-intranet-with-knime/87870 "2025-05-16T03:12:43Z")
Hello! :wave:t4: I hope you are all well. I have a technical situation and I hope to find help here… In the company I work for, we are using the free version of Knime, and we work with a local network (intranet). When… --- ## [Date Range Check for Customers](https://forum.knime.com/t/date-range-check-for-customers/87872)
**Author:** [@Sameer\_VOne](https://forum.knime.com/u/Sameer_VOne)\ **Replies:** 3\ **Last updated:** [May 7, 2025, 3:19am UTC](https://forum.knime.com/t/date-range-check-for-customers/87872 "2025-05-07T03:19:36Z")
Hi, I am working on a data set from CSV file where I have a column called Effective date. I want to create a validation check for the column where effective date should not be older than 1950-01-01 and should not be gr… --- ## [Automatically use the last 300 days from the column filter](https://forum.knime.com/t/automatically-use-the-last-300-days-from-the-column-filter/87671)
**Author:** [@Gavin02](https://forum.knime.com/u/Gavin02)\ **Replies:** 8\ **Last updated:** [April 18, 2025, 11:19pm UTC](https://forum.knime.com/t/automatically-use-the-last-300-days-from-the-column-filter/87671 "2025-04-18T23:19:02Z")
Column Filter automated.knwf (270.9 KB) Hello KNIME Community I have built a workflow that shows me the share history of the last few years. The problem is that I have manually set the ColumnFilter to the last 300 days… --- ## [Date format statements in Spark SQL Query nodes](https://forum.knime.com/t/date-format-statements-in-spark-sql-query-nodes/87480)
**Author:** [@JaeHwanChoi](https://forum.knime.com/u/JaeHwanChoi)\ **Replies:** 1\ **Last updated:** [April 15, 2025, 5:30pm UTC](https://forum.knime.com/t/date-format-statements-in-spark-sql-query-nodes/87480 "2025-04-15T17:30:16Z")
Hi, I have a question for the Nim Support team. I am currently trying to create a date column via Spark SQL Query. When I run the query below, the date data is generated in a different format and not represented in the… --- ## [Heatmap and SHAP graph troubles](https://forum.knime.com/t/heatmap-and-shap-graph-troubles/87604)
**Author:** [@Xin\_12](https://forum.knime.com/u/Xin_12)\ **Replies:** 1\ **Last updated:** [April 12, 2025, 1:59am UTC](https://forum.knime.com/t/heatmap-and-shap-graph-troubles/87604 "2025-04-12T01:59:27Z")
Hi guys, the first graph is the heatmap after the normalization, random forest, cross validation… But I want the x- and y-axis show the parameters, not the number. (I’ve asked about denormalizer and the parameters are st… --- ## [Text Processing - Finding a set of words within a cell](https://forum.knime.com/t/text-processing-finding-a-set-of-words-within-a-cell/87589)
**Author:** [@Lena\_Schmid](https://forum.knime.com/u/Lena_Schmid)\ **Replies:** 2\ **Last updated:** [April 10, 2025, 5:01pm UTC](https://forum.knime.com/t/text-processing-finding-a-set-of-words-within-a-cell/87589 "2025-04-10T17:01:20Z")
Hey, I’m new to more extensive text processing within knime so I’m not really sure where to start. I have the following issue: I have a column which contains products however, these products might be missspelled or som… [Next page](https://forum.knime.com/tag/big-data/137.md?match_all_tags=true&page=1&tags%5B%5D=big-data)