Early Access: The content on this website is provided for informational purposes only in connection with pre-General Availability Qlik Products.
All content is subject to change and is provided without warranty.
Skip to main content
Qlik Resources

Prerequisites

Before you begin to work with Amazon EMR as a target in Qlik Replicate, make sure that the following prerequisites have been met:

  • General:

    • The Amazon S3 bucket you are using must be accessible from the Qlik Replicate machine.
    • The user specified in the Amazon EMR target endpoint's Hive access settings must have access to HiveServer2.

  • ODBC Driver when Replicate Server is running on Windows:

  • Install Amazon Hive ODBC driver 2.6.9.1009 or later on the Replicate Server machine.

  • ODBC Driver when Replicate Server is running on Linux:

  1. Install Amazon Hive ODBC driver 2.6.9.1009 or later on the Replicate Server machine.

  2. After the driver is installed, edit the amazon.hiveodbc.ini file as follows:

    DriverManagerEncoding=UTF-16

    ODBCInstLib=libodbcinst.so

  • Permissions:
    • The Access settings selected in the Amazon EMR endpoint's Storage settings must have write access to the specified bucket folder.
      • Hive table permissions: Replicate requires permissions to perform the following operations on Hive tables: CREATE, DROP, DESCRIBE, and ALTER table. ALTER table may also include RENAME table, ADD/RENAME column, and CREATE/DROP partitions on tables.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Leave your feedback here