EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  3. Topics

Supported Apache Hive Datatypes

Norman Matos

Associate Scrum Master • Strategy

This tutorial reviews the Apache Hive data types that are supported in MicroStrategy.

Supported data types for Hive are listed below.
 

 
HP Vertica 7.2 64-bit Vertica ODBC Driver 7.20.xx.xx SupportedEnumeration ViewDssXmlViewMediaExportCSVExport to CSV.DssXmlViewMediaExportExcelExport to Excel with formatting.DssXmlViewMediaExportExcelPlainTextExport to Excel without formatting.DssXmlViewMediaExportFlashExport to Flash.DssXmlViewMediaExportHTMLExport to HTML.DssXmlViewMediaExportPDFExport to PDFDssXmlViewMediaExportPlainTextExport to Plain Text.DssXmlViewMediaReservedReserved for future usage.DssXmlViewMediaViewEditableEditable View.DssXmlViewMediaViewFlashFlash View.DssXmlViewMediaViewInteractiveInteractive View.DssXmlViewMediaViewStaticStatic (Express) View.LanguageKeyChinese (Simplified)804Chinese (Traditional)404Danish6Dutch13English9FrenchCGerman7Italian10Japanese11Korean12Polish15Portuguese16Russian19SpanishASwedish1DHive Data typeStrategy Data typeBIGINTDECIMALBINARYBinaryCHARCHARDATEDATEDECIMALDECIMALDOUBLEDOUBLEFLOATFLOATINTEGERINTEGERSMALLINTINTEGERTIMESTAMPTIMESTAMPTINYINTINTEGERVARCHARVARCHARSTRINGSTRING

 
HP Vertica 7.2 64-bit Vertica ODBC Driver 7.20.xx.xx SupportedEnumeration ViewDssXmlViewMediaExportCSVExport to CSV.DssXmlViewMediaExportExcelExport to Excel with formatting.DssXmlViewMediaExportExcelPlainTextExport to Excel without formatting.DssXmlViewMediaExportFlashExport to Flash.DssXmlViewMediaExportHTMLExport to HTML.DssXmlViewMediaExportPDFExport to PDFDssXmlViewMediaExportPlainTextExport to Plain Text.DssXmlViewMediaReservedReserved for future usage.DssXmlViewMediaViewEditableEditable View.DssXmlViewMediaViewFlashFlash View.DssXmlViewMediaViewInteractiveInteractive View.DssXmlViewMediaViewStaticStatic (Express) View.LanguageKeyChinese (Simplified)804Chinese (Traditional)404Danish6Dutch13English9FrenchCGerman7Italian10Japanese11Korean12Polish15Portuguese16Russian19SpanishASwedish1DHive Data typeStrategy Data typeBIGINTDECIMALBINARYBinaryCHARCHARDATEDATEDECIMALDECIMALDOUBLEDOUBLEFLOATFLOATINTEGERINTEGERSMALLINTINTEGERTIMESTAMPTIMESTAMPTINYINTINTEGERVARCHARVARCHARSTRINGSTRING

 
HP Vertica 7.2 64-bit Vertica ODBC Driver 7.20.xx.xx SupportedEnumeration ViewDssXmlViewMediaExportCSVExport to CSV.DssXmlViewMediaExportExcelExport to Excel with formatting.DssXmlViewMediaExportExcelPlainTextExport to Excel without formatting.DssXmlViewMediaExportFlashExport to Flash.DssXmlViewMediaExportHTMLExport to HTML.DssXmlViewMediaExportPDFExport to PDFDssXmlViewMediaExportPlainTextExport to Plain Text.DssXmlViewMediaReservedReserved for future usage.DssXmlViewMediaViewEditableEditable View.DssXmlViewMediaViewFlashFlash View.DssXmlViewMediaViewInteractiveInteractive View.DssXmlViewMediaViewStaticStatic (Express) View.LanguageKeyChinese (Simplified)804Chinese (Traditional)404Danish6Dutch13English9FrenchCGerman7Italian10Japanese11Korean12Polish15Portuguese16Russian19SpanishASwedish1DHive Data typeStrategy Data typeBIGINTDECIMALBINARYBinaryCHARCHARDATEDATEDECIMALDECIMALDOUBLEDOUBLEFLOATFLOATINTEGERINTEGERSMALLINTINTEGERTIMESTAMPTIMESTAMPTINYINTINTEGERVARCHARVARCHARSTRINGSTRING

 
HP Vertica 7.2 64-bit Vertica ODBC Driver 7.20.xx.xx SupportedEnumeration ViewDssXmlViewMediaExportCSVExport to CSV.DssXmlViewMediaExportExcelExport to Excel with formatting.DssXmlViewMediaExportExcelPlainTextExport to Excel without formatting.DssXmlViewMediaExportFlashExport to Flash.DssXmlViewMediaExportHTMLExport to HTML.DssXmlViewMediaExportPDFExport to PDFDssXmlViewMediaExportPlainTextExport to Plain Text.DssXmlViewMediaReservedReserved for future usage.DssXmlViewMediaViewEditableEditable View.DssXmlViewMediaViewFlashFlash View.DssXmlViewMediaViewInteractiveInteractive View.DssXmlViewMediaViewStaticStatic (Express) View.LanguageKeyChinese (Simplified)804Chinese (Traditional)404Danish6Dutch13English9FrenchCGerman7Italian10Japanese11Korean12Polish15Portuguese16Russian19SpanishASwedish1DHive Data typeStrategy Data typeBIGINTDECIMALBINARYBinaryCHARCHARDATEDATEDECIMALDECIMALDOUBLEDOUBLEFLOATFLOATINTEGERINTEGERSMALLINTINTEGERTIMESTAMPTIMESTAMPTINYINTINTEGERVARCHARVARCHARSTRINGSTRING

 
HP Vertica 7.2 64-bit Vertica ODBC Driver 7.20.xx.xx SupportedEnumeration ViewDssXmlViewMediaExportCSVExport to CSV.DssXmlViewMediaExportExcelExport to Excel with formatting.DssXmlViewMediaExportExcelPlainTextExport to Excel without formatting.DssXmlViewMediaExportFlashExport to Flash.DssXmlViewMediaExportHTMLExport to HTML.DssXmlViewMediaExportPDFExport to PDFDssXmlViewMediaExportPlainTextExport to Plain Text.DssXmlViewMediaReservedReserved for future usage.DssXmlViewMediaViewEditableEditable View.DssXmlViewMediaViewFlashFlash View.DssXmlViewMediaViewInteractiveInteractive View.DssXmlViewMediaViewStaticStatic (Express) View.LanguageKeyChinese (Simplified)804Chinese (Traditional)404Danish6Dutch13English9FrenchCGerman7Italian10Japanese11Korean12Polish15Portuguese16Russian19SpanishASwedish1DHive Data typeStrategy Data typeBIGINTDECIMALBINARYBinaryCHARCHARDATEDATEDECIMALDECIMALDOUBLEDOUBLEFLOATFLOATINTEGERINTEGERSMALLINTINTEGERTIMESTAMPTIMESTAMPTINYINTINTEGERVARCHARVARCHARSTRINGSTRING

 
HP Vertica 7.2 64-bit Vertica ODBC Driver 7.20.xx.xx SupportedEnumeration ViewDssXmlViewMediaExportCSVExport to CSV.DssXmlViewMediaExportExcelExport to Excel with formatting.DssXmlViewMediaExportExcelPlainTextExport to Excel without formatting.DssXmlViewMediaExportFlashExport to Flash.DssXmlViewMediaExportHTMLExport to HTML.DssXmlViewMediaExportPDFExport to PDFDssXmlViewMediaExportPlainTextExport to Plain Text.DssXmlViewMediaReservedReserved for future usage.DssXmlViewMediaViewEditableEditable View.DssXmlViewMediaViewFlashFlash View.DssXmlViewMediaViewInteractiveInteractive View.DssXmlViewMediaViewStaticStatic (Express) View.LanguageKeyChinese (Simplified)804Chinese (Traditional)404Danish6Dutch13English9FrenchCGerman7Italian10Japanese11Korean12Polish15Portuguese16Russian19SpanishASwedish1DHive Data typeStrategy Data typeBIGINTDECIMALBINARYBinaryCHARCHARDATEDATEDECIMALDECIMALDOUBLEDOUBLEFLOATFLOATINTEGERINTEGERSMALLINTINTEGERTIMESTAMPTIMESTAMPTINYINTINTEGERVARCHARVARCHARSTRINGSTRING

 
HP Vertica 7.2 64-bit Vertica ODBC Driver 7.20.xx.xx SupportedEnumeration ViewDssXmlViewMediaExportCSVExport to CSV.DssXmlViewMediaExportExcelExport to Excel with formatting.DssXmlViewMediaExportExcelPlainTextExport to Excel without formatting.DssXmlViewMediaExportFlashExport to Flash.DssXmlViewMediaExportHTMLExport to HTML.DssXmlViewMediaExportPDFExport to PDFDssXmlViewMediaExportPlainTextExport to Plain Text.DssXmlViewMediaReservedReserved for future usage.DssXmlViewMediaViewEditableEditable View.DssXmlViewMediaViewFlashFlash View.DssXmlViewMediaViewInteractiveInteractive View.DssXmlViewMediaViewStaticStatic (Express) View.LanguageKeyChinese (Simplified)804Chinese (Traditional)404Danish6Dutch13English9FrenchCGerman7Italian10Japanese11Korean12Polish15Portuguese16Russian19SpanishASwedish1DHive Data typeStrategy Data typeBIGINTDECIMALBINARYBinaryCHARCHARDATEDATEDECIMALDECIMALDOUBLEDOUBLEFLOATFLOATINTEGERINTEGERSMALLINTINTEGERTIMESTAMPTIMESTAMPTINYINTINTEGERVARCHARVARCHARSTRINGSTRING

 
HP Vertica 7.2 64-bit Vertica ODBC Driver 7.20.xx.xx SupportedEnumeration ViewDssXmlViewMediaExportCSVExport to CSV.DssXmlViewMediaExportExcelExport to Excel with formatting.DssXmlViewMediaExportExcelPlainTextExport to Excel without formatting.DssXmlViewMediaExportFlashExport to Flash.DssXmlViewMediaExportHTMLExport to HTML.DssXmlViewMediaExportPDFExport to PDFDssXmlViewMediaExportPlainTextExport to Plain Text.DssXmlViewMediaReservedReserved for future usage.DssXmlViewMediaViewEditableEditable View.DssXmlViewMediaViewFlashFlash View.DssXmlViewMediaViewInteractiveInteractive View.DssXmlViewMediaViewStaticStatic (Express) View.LanguageKeyChinese (Simplified)804Chinese (Traditional)404Danish6Dutch13English9FrenchCGerman7Italian10Japanese11Korean12Polish15Portuguese16Russian19SpanishASwedish1DHive Data typeStrategy Data typeBIGINTDECIMALBINARYBinaryCHARCHARDATEDATEDECIMALDECIMALDOUBLEDOUBLEFLOATFLOATINTEGERINTEGERSMALLINTINTEGERTIMESTAMPTIMESTAMPTINYINTINTEGERVARCHARVARCHARSTRINGSTRING

 
HP Vertica 7.2 64-bit Vertica ODBC Driver 7.20.xx.xx SupportedEnumeration ViewDssXmlViewMediaExportCSVExport to CSV.DssXmlViewMediaExportExcelExport to Excel with formatting.DssXmlViewMediaExportExcelPlainTextExport to Excel without formatting.DssXmlViewMediaExportFlashExport to Flash.DssXmlViewMediaExportHTMLExport to HTML.DssXmlViewMediaExportPDFExport to PDFDssXmlViewMediaExportPlainTextExport to Plain Text.DssXmlViewMediaReservedReserved for future usage.DssXmlViewMediaViewEditableEditable View.DssXmlViewMediaViewFlashFlash View.DssXmlViewMediaViewInteractiveInteractive View.DssXmlViewMediaViewStaticStatic (Express) View.LanguageKeyChinese (Simplified)804Chinese (Traditional)404Danish6Dutch13English9FrenchCGerman7Italian10Japanese11Korean12Polish15Portuguese16Russian19SpanishASwedish1DHive Data typeStrategy Data typeBIGINTDECIMALBINARYBinaryCHARCHARDATEDATEDECIMALDECIMALDOUBLEDOUBLEFLOATFLOATINTEGERINTEGERSMALLINTINTEGERTIMESTAMPTIMESTAMPTINYINTINTEGERVARCHARVARCHARSTRINGSTRING

 
HP Vertica 7.2 64-bit Vertica ODBC Driver 7.20.xx.xx SupportedEnumeration ViewDssXmlViewMediaExportCSVExport to CSV.DssXmlViewMediaExportExcelExport to Excel with formatting.DssXmlViewMediaExportExcelPlainTextExport to Excel without formatting.DssXmlViewMediaExportFlashExport to Flash.DssXmlViewMediaExportHTMLExport to HTML.DssXmlViewMediaExportPDFExport to PDFDssXmlViewMediaExportPlainTextExport to Plain Text.DssXmlViewMediaReservedReserved for future usage.DssXmlViewMediaViewEditableEditable View.DssXmlViewMediaViewFlashFlash View.DssXmlViewMediaViewInteractiveInteractive View.DssXmlViewMediaViewStaticStatic (Express) View.LanguageKeyChinese (Simplified)804Chinese (Traditional)404Danish6Dutch13English9FrenchCGerman7Italian10Japanese11Korean12Polish15Portuguese16Russian19SpanishASwedish1DHive Data typeStrategy Data typeBIGINTDECIMALBINARYBinaryCHARCHARDATEDATEDECIMALDECIMALDOUBLEDOUBLEFLOATFLOATINTEGERINTEGERSMALLINTINTEGERTIMESTAMPTIMESTAMPTINYINTINTEGERVARCHARVARCHARSTRINGSTRING

 
HP Vertica 7.2 64-bit Vertica ODBC Driver 7.20.xx.xx SupportedEnumeration ViewDssXmlViewMediaExportCSVExport to CSV.DssXmlViewMediaExportExcelExport to Excel with formatting.DssXmlViewMediaExportExcelPlainTextExport to Excel without formatting.DssXmlViewMediaExportFlashExport to Flash.DssXmlViewMediaExportHTMLExport to HTML.DssXmlViewMediaExportPDFExport to PDFDssXmlViewMediaExportPlainTextExport to Plain Text.DssXmlViewMediaReservedReserved for future usage.DssXmlViewMediaViewEditableEditable View.DssXmlViewMediaViewFlashFlash View.DssXmlViewMediaViewInteractiveInteractive View.DssXmlViewMediaViewStaticStatic (Express) View.LanguageKeyChinese (Simplified)804Chinese (Traditional)404Danish6Dutch13English9FrenchCGerman7Italian10Japanese11Korean12Polish15Portuguese16Russian19SpanishASwedish1DHive Data typeStrategy Data typeBIGINTDECIMALBINARYBinaryCHARCHARDATEDATEDECIMALDECIMALDOUBLEDOUBLEFLOATFLOATINTEGERINTEGERSMALLINTINTEGERTIMESTAMPTIMESTAMPTINYINTINTEGERVARCHARVARCHARSTRINGSTRING

 
HP Vertica 7.2 64-bit Vertica ODBC Driver 7.20.xx.xx SupportedEnumeration ViewDssXmlViewMediaExportCSVExport to CSV.DssXmlViewMediaExportExcelExport to Excel with formatting.DssXmlViewMediaExportExcelPlainTextExport to Excel without formatting.DssXmlViewMediaExportFlashExport to Flash.DssXmlViewMediaExportHTMLExport to HTML.DssXmlViewMediaExportPDFExport to PDFDssXmlViewMediaExportPlainTextExport to Plain Text.DssXmlViewMediaReservedReserved for future usage.DssXmlViewMediaViewEditableEditable View.DssXmlViewMediaViewFlashFlash View.DssXmlViewMediaViewInteractiveInteractive View.DssXmlViewMediaViewStaticStatic (Express) View.LanguageKeyChinese (Simplified)804Chinese (Traditional)404Danish6Dutch13English9FrenchCGerman7Italian10Japanese11Korean12Polish15Portuguese16Russian19SpanishASwedish1DHive Data typeStrategy Data typeBIGINTDECIMALBINARYBinaryCHARCHARDATEDATEDECIMALDECIMALDOUBLEDOUBLEFLOATFLOATINTEGERINTEGERSMALLINTINTEGERTIMESTAMPTIMESTAMPTINYINTINTEGERVARCHARVARCHARSTRINGSTRING

 
HP Vertica 7.2 64-bit Vertica ODBC Driver 7.20.xx.xx SupportedEnumeration ViewDssXmlViewMediaExportCSVExport to CSV.DssXmlViewMediaExportExcelExport to Excel with formatting.DssXmlViewMediaExportExcelPlainTextExport to Excel without formatting.DssXmlViewMediaExportFlashExport to Flash.DssXmlViewMediaExportHTMLExport to HTML.DssXmlViewMediaExportPDFExport to PDFDssXmlViewMediaExportPlainTextExport to Plain Text.DssXmlViewMediaReservedReserved for future usage.DssXmlViewMediaViewEditableEditable View.DssXmlViewMediaViewFlashFlash View.DssXmlViewMediaViewInteractiveInteractive View.DssXmlViewMediaViewStaticStatic (Express) View.LanguageKeyChinese (Simplified)804Chinese (Traditional)404Danish6Dutch13English9FrenchCGerman7Italian10Japanese11Korean12Polish15Portuguese16Russian19SpanishASwedish1DHive Data typeStrategy Data typeBIGINTDECIMALBINARYBinaryCHARCHARDATEDATEDECIMALDECIMALDOUBLEDOUBLEFLOATFLOATINTEGERINTEGERSMALLINTINTEGERTIMESTAMPTIMESTAMPTINYINTINTEGERVARCHARVARCHARSTRINGSTRING

 
HP Vertica 7.2 64-bit Vertica ODBC Driver 7.20.xx.xx SupportedEnumeration ViewDssXmlViewMediaExportCSVExport to CSV.DssXmlViewMediaExportExcelExport to Excel with formatting.DssXmlViewMediaExportExcelPlainTextExport to Excel without formatting.DssXmlViewMediaExportFlashExport to Flash.DssXmlViewMediaExportHTMLExport to HTML.DssXmlViewMediaExportPDFExport to PDFDssXmlViewMediaExportPlainTextExport to Plain Text.DssXmlViewMediaReservedReserved for future usage.DssXmlViewMediaViewEditableEditable View.DssXmlViewMediaViewFlashFlash View.DssXmlViewMediaViewInteractiveInteractive View.DssXmlViewMediaViewStaticStatic (Express) View.LanguageKeyChinese (Simplified)804Chinese (Traditional)404Danish6Dutch13English9FrenchCGerman7Italian10Japanese11Korean12Polish15Portuguese16Russian19SpanishASwedish1DHive Data typeStrategy Data typeBIGINTDECIMALBINARYBinaryCHARCHARDATEDATEDECIMALDECIMALDOUBLEDOUBLEFLOATFLOATINTEGERINTEGERSMALLINTINTEGERTIMESTAMPTIMESTAMPTINYINTINTEGERVARCHARVARCHARSTRINGSTRING

 
HP Vertica 7.2 64-bit Vertica ODBC Driver 7.20.xx.xx SupportedEnumeration ViewDssXmlViewMediaExportCSVExport to CSV.DssXmlViewMediaExportExcelExport to Excel with formatting.DssXmlViewMediaExportExcelPlainTextExport to Excel without formatting.DssXmlViewMediaExportFlashExport to Flash.DssXmlViewMediaExportHTMLExport to HTML.DssXmlViewMediaExportPDFExport to PDFDssXmlViewMediaExportPlainTextExport to Plain Text.DssXmlViewMediaReservedReserved for future usage.DssXmlViewMediaViewEditableEditable View.DssXmlViewMediaViewFlashFlash View.DssXmlViewMediaViewInteractiveInteractive View.DssXmlViewMediaViewStaticStatic (Express) View.LanguageKeyChinese (Simplified)804Chinese (Traditional)404Danish6Dutch13English9FrenchCGerman7Italian10Japanese11Korean12Polish15Portuguese16Russian19SpanishASwedish1DHive Data typeStrategy Data typeBIGINTDECIMALBINARYBinaryCHARCHARDATEDATEDECIMALDECIMALDOUBLEDOUBLEFLOATFLOATINTEGERINTEGERSMALLINTINTEGERTIMESTAMPTIMESTAMPTINYINTINTEGERVARCHARVARCHARSTRINGSTRING

 
HP Vertica 7.2 64-bit Vertica ODBC Driver 7.20.xx.xx SupportedEnumeration ViewDssXmlViewMediaExportCSVExport to CSV.DssXmlViewMediaExportExcelExport to Excel with formatting.DssXmlViewMediaExportExcelPlainTextExport to Excel without formatting.DssXmlViewMediaExportFlashExport to Flash.DssXmlViewMediaExportHTMLExport to HTML.DssXmlViewMediaExportPDFExport to PDFDssXmlViewMediaExportPlainTextExport to Plain Text.DssXmlViewMediaReservedReserved for future usage.DssXmlViewMediaViewEditableEditable View.DssXmlViewMediaViewFlashFlash View.DssXmlViewMediaViewInteractiveInteractive View.DssXmlViewMediaViewStaticStatic (Express) View.LanguageKeyChinese (Simplified)804Chinese (Traditional)404Danish6Dutch13English9FrenchCGerman7Italian10Japanese11Korean12Polish15Portuguese16Russian19SpanishASwedish1DHive Data typeStrategy Data typeBIGINTDECIMALBINARYBinaryCHARCHARDATEDATEDECIMALDECIMALDOUBLEDOUBLEFLOATFLOATINTEGERINTEGERSMALLINTINTEGERTIMESTAMPTIMESTAMPTINYINTINTEGERVARCHARVARCHARSTRINGSTRING

 
HP Vertica 7.2 64-bit Vertica ODBC Driver 7.20.xx.xx SupportedEnumeration ViewDssXmlViewMediaExportCSVExport to CSV.DssXmlViewMediaExportExcelExport to Excel with formatting.DssXmlViewMediaExportExcelPlainTextExport to Excel without formatting.DssXmlViewMediaExportFlashExport to Flash.DssXmlViewMediaExportHTMLExport to HTML.DssXmlViewMediaExportPDFExport to PDFDssXmlViewMediaExportPlainTextExport to Plain Text.DssXmlViewMediaReservedReserved for future usage.DssXmlViewMediaViewEditableEditable View.DssXmlViewMediaViewFlashFlash View.DssXmlViewMediaViewInteractiveInteractive View.DssXmlViewMediaViewStaticStatic (Express) View.LanguageKeyChinese (Simplified)804Chinese (Traditional)404Danish6Dutch13English9FrenchCGerman7Italian10Japanese11Korean12Polish15Portuguese16Russian19SpanishASwedish1DHive Data typeStrategy Data typeBIGINTDECIMALBINARYBinaryCHARCHARDATEDATEDECIMALDECIMALDOUBLEDOUBLEFLOATFLOATINTEGERINTEGERSMALLINTINTEGERTIMESTAMPTIMESTAMPTINYINTINTEGERVARCHARVARCHARSTRINGSTRING

 
HP Vertica 7.2 64-bit Vertica ODBC Driver 7.20.xx.xx SupportedEnumeration ViewDssXmlViewMediaExportCSVExport to CSV.DssXmlViewMediaExportExcelExport to Excel with formatting.DssXmlViewMediaExportExcelPlainTextExport to Excel without formatting.DssXmlViewMediaExportFlashExport to Flash.DssXmlViewMediaExportHTMLExport to HTML.DssXmlViewMediaExportPDFExport to PDFDssXmlViewMediaExportPlainTextExport to Plain Text.DssXmlViewMediaReservedReserved for future usage.DssXmlViewMediaViewEditableEditable View.DssXmlViewMediaViewFlashFlash View.DssXmlViewMediaViewInteractiveInteractive View.DssXmlViewMediaViewStaticStatic (Express) View.LanguageKeyChinese (Simplified)804Chinese (Traditional)404Danish6Dutch13English9FrenchCGerman7Italian10Japanese11Korean12Polish15Portuguese16Russian19SpanishASwedish1DHive Data typeStrategy Data typeBIGINTDECIMALBINARYBinaryCHARCHARDATEDATEDECIMALDECIMALDOUBLEDOUBLEFLOATFLOATINTEGERINTEGERSMALLINTINTEGERTIMESTAMPTIMESTAMPTINYINTINTEGERVARCHARVARCHARSTRINGSTRING

 
HP Vertica 7.2 64-bit Vertica ODBC Driver 7.20.xx.xx SupportedEnumeration ViewDssXmlViewMediaExportCSVExport to CSV.DssXmlViewMediaExportExcelExport to Excel with formatting.DssXmlViewMediaExportExcelPlainTextExport to Excel without formatting.DssXmlViewMediaExportFlashExport to Flash.DssXmlViewMediaExportHTMLExport to HTML.DssXmlViewMediaExportPDFExport to PDFDssXmlViewMediaExportPlainTextExport to Plain Text.DssXmlViewMediaReservedReserved for future usage.DssXmlViewMediaViewEditableEditable View.DssXmlViewMediaViewFlashFlash View.DssXmlViewMediaViewInteractiveInteractive View.DssXmlViewMediaViewStaticStatic (Express) View.LanguageKeyChinese (Simplified)804Chinese (Traditional)404Danish6Dutch13English9FrenchCGerman7Italian10Japanese11Korean12Polish15Portuguese16Russian19SpanishASwedish1DHive Data typeStrategy Data typeBIGINTDECIMALBINARYBinaryCHARCHARDATEDATEDECIMALDECIMALDOUBLEDOUBLEFLOATFLOATINTEGERINTEGERSMALLINTINTEGERTIMESTAMPTIMESTAMPTINYINTINTEGERVARCHARVARCHARSTRINGSTRING

 
HP Vertica 7.2 64-bit Vertica ODBC Driver 7.20.xx.xx SupportedEnumeration ViewDssXmlViewMediaExportCSVExport to CSV.DssXmlViewMediaExportExcelExport to Excel with formatting.DssXmlViewMediaExportExcelPlainTextExport to Excel without formatting.DssXmlViewMediaExportFlashExport to Flash.DssXmlViewMediaExportHTMLExport to HTML.DssXmlViewMediaExportPDFExport to PDFDssXmlViewMediaExportPlainTextExport to Plain Text.DssXmlViewMediaReservedReserved for future usage.DssXmlViewMediaViewEditableEditable View.DssXmlViewMediaViewFlashFlash View.DssXmlViewMediaViewInteractiveInteractive View.DssXmlViewMediaViewStaticStatic (Express) View.LanguageKeyChinese (Simplified)804Chinese (Traditional)404Danish6Dutch13English9FrenchCGerman7Italian10Japanese11Korean12Polish15Portuguese16Russian19SpanishASwedish1DHive Data typeStrategy Data typeBIGINTDECIMALBINARYBinaryCHARCHARDATEDATEDECIMALDECIMALDOUBLEDOUBLEFLOATFLOATINTEGERINTEGERSMALLINTINTEGERTIMESTAMPTIMESTAMPTINYINTINTEGERVARCHARVARCHARSTRINGSTRING

 
HP Vertica 7.2 64-bit Vertica ODBC Driver 7.20.xx.xx SupportedEnumeration ViewDssXmlViewMediaExportCSVExport to CSV.DssXmlViewMediaExportExcelExport to Excel with formatting.DssXmlViewMediaExportExcelPlainTextExport to Excel without formatting.DssXmlViewMediaExportFlashExport to Flash.DssXmlViewMediaExportHTMLExport to HTML.DssXmlViewMediaExportPDFExport to PDFDssXmlViewMediaExportPlainTextExport to Plain Text.DssXmlViewMediaReservedReserved for future usage.DssXmlViewMediaViewEditableEditable View.DssXmlViewMediaViewFlashFlash View.DssXmlViewMediaViewInteractiveInteractive View.DssXmlViewMediaViewStaticStatic (Express) View.LanguageKeyChinese (Simplified)804Chinese (Traditional)404Danish6Dutch13English9FrenchCGerman7Italian10Japanese11Korean12Polish15Portuguese16Russian19SpanishASwedish1DHive Data typeStrategy Data typeBIGINTDECIMALBINARYBinaryCHARCHARDATEDATEDECIMALDECIMALDOUBLEDOUBLEFLOATFLOATINTEGERINTEGERSMALLINTINTEGERTIMESTAMPTIMESTAMPTINYINTINTEGERVARCHARVARCHARSTRINGSTRING

 
HP Vertica 7.2 64-bit Vertica ODBC Driver 7.20.xx.xx SupportedEnumeration ViewDssXmlViewMediaExportCSVExport to CSV.DssXmlViewMediaExportExcelExport to Excel with formatting.DssXmlViewMediaExportExcelPlainTextExport to Excel without formatting.DssXmlViewMediaExportFlashExport to Flash.DssXmlViewMediaExportHTMLExport to HTML.DssXmlViewMediaExportPDFExport to PDFDssXmlViewMediaExportPlainTextExport to Plain Text.DssXmlViewMediaReservedReserved for future usage.DssXmlViewMediaViewEditableEditable View.DssXmlViewMediaViewFlashFlash View.DssXmlViewMediaViewInteractiveInteractive View.DssXmlViewMediaViewStaticStatic (Express) View.LanguageKeyChinese (Simplified)804Chinese (Traditional)404Danish6Dutch13English9FrenchCGerman7Italian10Japanese11Korean12Polish15Portuguese16Russian19SpanishASwedish1DHive Data typeStrategy Data typeBIGINTDECIMALBINARYBinaryCHARCHARDATEDATEDECIMALDECIMALDOUBLEDOUBLEFLOATFLOATINTEGERINTEGERSMALLINTINTEGERTIMESTAMPTIMESTAMPTINYINTINTEGERVARCHARVARCHARSTRINGSTRING

 
HP Vertica 7.2 64-bit Vertica ODBC Driver 7.20.xx.xx SupportedEnumeration ViewDssXmlViewMediaExportCSVExport to CSV.DssXmlViewMediaExportExcelExport to Excel with formatting.DssXmlViewMediaExportExcelPlainTextExport to Excel without formatting.DssXmlViewMediaExportFlashExport to Flash.DssXmlViewMediaExportHTMLExport to HTML.DssXmlViewMediaExportPDFExport to PDFDssXmlViewMediaExportPlainTextExport to Plain Text.DssXmlViewMediaReservedReserved for future usage.DssXmlViewMediaViewEditableEditable View.DssXmlViewMediaViewFlashFlash View.DssXmlViewMediaViewInteractiveInteractive View.DssXmlViewMediaViewStaticStatic (Express) View.LanguageKeyChinese (Simplified)804Chinese (Traditional)404Danish6Dutch13English9FrenchCGerman7Italian10Japanese11Korean12Polish15Portuguese16Russian19SpanishASwedish1DHive Data typeStrategy Data typeBIGINTDECIMALBINARYBinaryCHARCHARDATEDATEDECIMALDECIMALDOUBLEDOUBLEFLOATFLOATINTEGERINTEGERSMALLINTINTEGERTIMESTAMPTIMESTAMPTINYINTINTEGERVARCHARVARCHARSTRINGSTRING

 
HP Vertica 7.2 64-bit Vertica ODBC Driver 7.20.xx.xx SupportedEnumeration ViewDssXmlViewMediaExportCSVExport to CSV.DssXmlViewMediaExportExcelExport to Excel with formatting.DssXmlViewMediaExportExcelPlainTextExport to Excel without formatting.DssXmlViewMediaExportFlashExport to Flash.DssXmlViewMediaExportHTMLExport to HTML.DssXmlViewMediaExportPDFExport to PDFDssXmlViewMediaExportPlainTextExport to Plain Text.DssXmlViewMediaReservedReserved for future usage.DssXmlViewMediaViewEditableEditable View.DssXmlViewMediaViewFlashFlash View.DssXmlViewMediaViewInteractiveInteractive View.DssXmlViewMediaViewStaticStatic (Express) View.LanguageKeyChinese (Simplified)804Chinese (Traditional)404Danish6Dutch13English9FrenchCGerman7Italian10Japanese11Korean12Polish15Portuguese16Russian19SpanishASwedish1DHive Data typeStrategy Data typeBIGINTDECIMALBINARYBinaryCHARCHARDATEDATEDECIMALDECIMALDOUBLEDOUBLEFLOATFLOATINTEGERINTEGERSMALLINTINTEGERTIMESTAMPTIMESTAMPTINYINTINTEGERVARCHARVARCHARSTRINGSTRING

 
HP Vertica 7.2 64-bit Vertica ODBC Driver 7.20.xx.xx SupportedEnumeration ViewDssXmlViewMediaExportCSVExport to CSV.DssXmlViewMediaExportExcelExport to Excel with formatting.DssXmlViewMediaExportExcelPlainTextExport to Excel without formatting.DssXmlViewMediaExportFlashExport to Flash.DssXmlViewMediaExportHTMLExport to HTML.DssXmlViewMediaExportPDFExport to PDFDssXmlViewMediaExportPlainTextExport to Plain Text.DssXmlViewMediaReservedReserved for future usage.DssXmlViewMediaViewEditableEditable View.DssXmlViewMediaViewFlashFlash View.DssXmlViewMediaViewInteractiveInteractive View.DssXmlViewMediaViewStaticStatic (Express) View.LanguageKeyChinese (Simplified)804Chinese (Traditional)404Danish6Dutch13English9FrenchCGerman7Italian10Japanese11Korean12Polish15Portuguese16Russian19SpanishASwedish1DHive Data typeStrategy Data typeBIGINTDECIMALBINARYBinaryCHARCHARDATEDATEDECIMALDECIMALDOUBLEDOUBLEFLOATFLOATINTEGERINTEGERSMALLINTINTEGERTIMESTAMPTIMESTAMPTINYINTINTEGERVARCHARVARCHARSTRINGSTRING

 
HP Vertica 7.2 64-bit Vertica ODBC Driver 7.20.xx.xx SupportedEnumeration ViewDssXmlViewMediaExportCSVExport to CSV.DssXmlViewMediaExportExcelExport to Excel with formatting.DssXmlViewMediaExportExcelPlainTextExport to Excel without formatting.DssXmlViewMediaExportFlashExport to Flash.DssXmlViewMediaExportHTMLExport to HTML.DssXmlViewMediaExportPDFExport to PDFDssXmlViewMediaExportPlainTextExport to Plain Text.DssXmlViewMediaReservedReserved for future usage.DssXmlViewMediaViewEditableEditable View.DssXmlViewMediaViewFlashFlash View.DssXmlViewMediaViewInteractiveInteractive View.DssXmlViewMediaViewStaticStatic (Express) View.LanguageKeyChinese (Simplified)804Chinese (Traditional)404Danish6Dutch13English9FrenchCGerman7Italian10Japanese11Korean12Polish15Portuguese16Russian19SpanishASwedish1DHive Data typeStrategy Data typeBIGINTDECIMALBINARYBinaryCHARCHARDATEDATEDECIMALDECIMALDOUBLEDOUBLEFLOATFLOATINTEGERINTEGERSMALLINTINTEGERTIMESTAMPTIMESTAMPTINYINTINTEGERVARCHARVARCHARSTRINGSTRING

 
HP Vertica 7.2 64-bit Vertica ODBC Driver 7.20.xx.xx SupportedEnumeration ViewDssXmlViewMediaExportCSVExport to CSV.DssXmlViewMediaExportExcelExport to Excel with formatting.DssXmlViewMediaExportExcelPlainTextExport to Excel without formatting.DssXmlViewMediaExportFlashExport to Flash.DssXmlViewMediaExportHTMLExport to HTML.DssXmlViewMediaExportPDFExport to PDFDssXmlViewMediaExportPlainTextExport to Plain Text.DssXmlViewMediaReservedReserved for future usage.DssXmlViewMediaViewEditableEditable View.DssXmlViewMediaViewFlashFlash View.DssXmlViewMediaViewInteractiveInteractive View.DssXmlViewMediaViewStaticStatic (Express) View.LanguageKeyChinese (Simplified)804Chinese (Traditional)404Danish6Dutch13English9FrenchCGerman7Italian10Japanese11Korean12Polish15Portuguese16Russian19SpanishASwedish1DHive Data typeStrategy Data typeBIGINTDECIMALBINARYBinaryCHARCHARDATEDATEDECIMALDECIMALDOUBLEDOUBLEFLOATFLOATINTEGERINTEGERSMALLINTINTEGERTIMESTAMPTIMESTAMPTINYINTINTEGERVARCHARVARCHARSTRINGSTRING

 
HP Vertica 7.2 64-bit Vertica ODBC Driver 7.20.xx.xx SupportedEnumeration ViewDssXmlViewMediaExportCSVExport to CSV.DssXmlViewMediaExportExcelExport to Excel with formatting.DssXmlViewMediaExportExcelPlainTextExport to Excel without formatting.DssXmlViewMediaExportFlashExport to Flash.DssXmlViewMediaExportHTMLExport to HTML.DssXmlViewMediaExportPDFExport to PDFDssXmlViewMediaExportPlainTextExport to Plain Text.DssXmlViewMediaReservedReserved for future usage.DssXmlViewMediaViewEditableEditable View.DssXmlViewMediaViewFlashFlash View.DssXmlViewMediaViewInteractiveInteractive View.DssXmlViewMediaViewStaticStatic (Express) View.LanguageKeyChinese (Simplified)804Chinese (Traditional)404Danish6Dutch13English9FrenchCGerman7Italian10Japanese11Korean12Polish15Portuguese16Russian19SpanishASwedish1DHive Data typeStrategy Data typeBIGINTDECIMALBINARYBinaryCHARCHARDATEDATEDECIMALDECIMALDOUBLEDOUBLEFLOATFLOATINTEGERINTEGERSMALLINTINTEGERTIMESTAMPTIMESTAMPTINYINTINTEGERVARCHARVARCHARSTRINGSTRING

Unsupported data types for Hive in Strategy:
 

  • Boolean, Arrays, Maps, Structs, Union datatypes.
Comment

0 comments

Details

Knowledge Article

Published:

July 31, 2017

Last Updated:

July 31, 2017