Ga naar hoofdinhoud Ga naar aanvullende inhoud

Apache Phoenix

Connections to an Apache Phoenix database are made by selecting Apache Phoenix from the list of connectors in the Qlik Sense Add data or Data load editor dialogs.

Apache Phoenix is a relational database layer that is build on top of Apache HBase. Apache Phoenix compiles an SQL query into a series of HBase scans and executes those scans to produce result sets.

InformatieIndustry-accepted best practices must be followed when using or allowing access through the ODBC Connector. Administrators must follow The Principle of Least Privilege when setting up source database privileges and permissions.
InformatieThis data source is not available in Qlik Sense Business or Qlik Cloud Analyse Standaard.

Supported Apache Phoenix database versions

The followings database versions are supported:

  • CDH 4.4.0 to 4.7.0

Supported Apache Phoenix data types

The following Apache Phoenix data types are supported by the Apache Phoenix Connector.

  • Array
  • BigInt
  • Binary
  • Boolean
  • Char
  • Date
  • Decimal
  • Double
  • Float
  • Integer
  • SmallInt
  • Time
  • Timestamp
  • TinyInt
  • Unsigned_Date
  • Unsigned_Double
  • Unsigned_Float
  • Unsigned_Int
  • Unsigned_Long
  • Unsigned_SmallInt
  • Unsigned_Time
  • Unsigned_TimeStamp
  • Unsigned_TinyInt
  • Varchar

Was deze pagina nuttig?

Als u problemen ervaart op deze pagina of de inhoud onjuist is – een typfout, een ontbrekende stap of een technische fout – laat het ons weten zodat we dit kunnen verbeteren!