Hub

33 results

Filter
Filter by tag
Hive
Big Data Impala Knime Spark Db nodes Hadoop SQL
  1. Workflow
    Spark SQL meets Hive SQL
    Spark Hive Hadoop
    +3
    This workflow builds a line plot of the age distribution for men and women in Maine (US) over the last 5 years. In particular, wo…
    knime > Education > Courses > L4-BD Introduction to Big Data with KNIME Analytics Platform > 3_Spark > 4_Examples > 07_SparkSQL_meets_HiveQL
    0
    knime
  2. Workflow
    Spark SQL meets Hive SQL
    Spark Hive Hadoop
    +4
    This workflow builds a line plot of the age distribution for men and women in Maine (US) over the last 5 years. In particular, wo…
    knime > Examples > 10_Big_Data > 02_Spark_Executor > 07_SparkSQL_meets_HiveQL
    0
    knime
  3. Workflow
    Local big data Irish meter
    Hive Spark Spark PCA
    +7
    This workflow uses a portion of the Irish Energy Meter dataset, and presents a simple analysis based on the whitepaper "Big Data,…
    knime > Education > Courses > L4-BD Introduction to Big Data with KNIME Analytics Platform > 3_Spark > 4_Examples > 09_Big_Data_Irish_Meter_on_Spark_only
    0
    knime
  4. Workflow
    Local big data Irish meter
    Hive Spark Spark PCA
    +7
    This workflow uses a portion of the Irish Energy Meter dataset, and presents a simple analysis based on the whitepaper "Big Data,…
    knime > Examples > 10_Big_Data > 02_Spark_Executor > 09_Big_Data_Irish_Meter_on_Spark_only
    0
    knime
  5. Workflow
    A meta collection of KNIME and databases (SQL, Big Data/Hive/Impala and Spark/PySpark)
    Database Sql Hive
    +11
    A meta collection of KNIME and databases (SQL, Big Data/Hive/Impala and Spark/PySpark) KNIME as a powerful data anaylytics platfo…
    mlauber71 > Public > _db_sql_bigdata_hive_spark_meta_collection
    1
    mlauber71
  6. Workflow
    School of Hive - with KNIME's local Big Data environment (SQL for Big Data)
    Hive School Learn
    +12
    School of Hive - with KNIME's local Big Data environment (SQL for Big Data) Demonstrates a collection of Hive functions using KNI…
    mlauber71 > Public > kn_example_hive_school_of
    0
    mlauber71
  7. Workflow
    All inside BigData Predictive Approach. From Hive through Spark ETL till Spark Model Training.
    Hive ETL KNIME
    +4
    This workflow reads CENSUS data from a Hive database in HDInsight; it then moves to Spark where it performs some ETL operations; …
    knime > Examples > 40_Partners > 01_Microsoft > 04_HDI_Hive_Spark
    0
    knime
  8. Workflow
    add fields to Hive table
    Hive Sql Big data
    +2
    Use KNIME and Hive/SQL syntax to add columnd to a Big Data table (migrated to KNIME 4.0 and new DB nodes)
    mlauber71 > Public > kn_example_bigdata_hive_add_column_db_40
    0
    mlauber71
  9. Workflow
    KNIME and Hive - load multiple CSV files at once via external table
    Knime Hive External
    +5
    KNIME and Hive - load multiple CSV files at once via external table. Also: toy around with internal and external tables and then …
    mlauber71 > Public > kn_example_bigdata_hive_csv_loader > m_001_import_hive_csv
    0
    mlauber71
  10. Workflow
    Big Data preprocessing
    Hive Hadoop Big Data
    +2
    This workflow demonstrates the usage of the DB nodes in conjunction with the Create Local Big Data Environment node, which is par…
    knime > Education > Courses > L4-BD Introduction to Big Data with KNIME Analytics Platform > 2_Hadoop > 4_Examples > 01_Big_Data_Preprocessing_Example
    0
    knime
  11. Workflow
    Big Data preprocessing
    Hive Hadoop Big Data
    +2
    This workflow demonstrates the usage of the DB nodes in conjunction with the Create Local Big Data Environment node, which is par…
    knime > Examples > 10_Big_Data > 01_Big_Data_Connectors > 01_Big_Data_Preprocessing_Example
    0
    knime
  12. Workflow
    Hive - how to handle missing tables in Hive?
    Big data Hive Impala
    +6
    use try and catch for generic ports. The existing table will be at the resulting port Try some generic SQL operation on your Hive…
    mlauber71 > Public > kn_example_hive_missing_table_switch
    0
    mlauber71
  13. Workflow
    This workflow demonstrates several methods to import one or many CSV file into Hive
    Knime Hive External
    +5
    This workflow demonstrates several methods to import one or many CSV file into Hive Demonstrated are direct Uploads where you cre…
    mlauber71 > Public > kn_example_bigdata_hive_csv_external_table > m_001_import_hive_csv
    0
    mlauber71
  14. Workflow
    Working with Azure services
    Azure Microsoft Hdinsight
    +6
    This workflow demonstrates how to connect to various Azure services such as HDInsight clusters, Azure Blob Storage, and AzureSQL …
    knime > Examples > 10_Big_Data > 01_Big_Data_Connectors > 09_AzureExample
    0
    knime
  15. Workflow
    add fields to Hive table
    Hive Sql Big data
    There has been no description set for this workflow's metadata.
    mlauber71 > Public > kn_example_bigdata_hive_add_column
    0
    mlauber71
  16. Workflow
    Create HIVE table and show the way it was created and describe the structure
    Hive Big data Knime
    +3
    Create a Big Data table, show the structiure and fields
    mbergman > Public > kn_example_hive_create_table_show_describe
    0
    mbergman
  17. Workflow
    Hive - how to get from DB-Connectors to Hive (or Impala) tables
    Big data Hive Impala
    +2
    Hive - how to get from DB-Connectors to Hive (or Impala) tables There does not seem to be a direct way to get from the comfortabl…
    mlauber71 > Public > kn_example_hive_db_loader_40
    0
    mlauber71
  18. Workflow
    Hive - how to get from DB-Connectors to Hive (or Impala) tables - KNIME 4.3+
    Big data Hive Impala
    +2
    Hive - how to get from DB-Connectors to Hive (or Impala) tables There does not seem to be a direct way to get from the comfortabl…
    mlauber71 > Public > kn_example_hive_db_loader_43
    0
    mlauber71
  19. Workflow
    Create HIVE table and show the way it was created and describe the structure
    Hive Big data Knime
    +3
    Create a Big Data table, show the structiure and fields
    mlauber71 > Public > kn_example_hive_create_table_show_describe
    0
    mlauber71
  20. Workflow
    Hive to Spark and Spark to Hive
    Spark Hive Hadoop
    +2
    This workflow demonstrates the usage of the Hive to Spark and Spark to Hive nodes that allow you to transfer data between Apache …
    knime > Education > Courses > L4-BD Introduction to Big Data with KNIME Analytics Platform > 3_Spark > 4_Examples > 05_Hive_to_Spark_to_Hive
    0
    knime