Hello, I tried to connect hive from a windows server via odbc but without success. My cluster hadoop is kerberized, hive port is 10000 and is open between windows and all the cluster (I did a telnet serverhive2 10000 and it works) I download HortonworksHiveODBC64.msi and install it. I tried a lot of combination of parameters on "hortons Hive ODBC Driver DSN setup", none of them works, for sample this setting: give me this error: [Hortonworks][Hardy] (34) Error from server: SASL(-1): generic failure: GSSAPI Error: Unspecified GSS failure. Minor code may provide more information (Permission denied). [Hortonworks][Hardy] (34) Error from server: SASL(0): successful result: . what have I to do to set correctly my odbc driver ... View more

Hello, I would like to create an hive table which take as input something like this: ... ----------------------------------------------------------------------------------------------------- USER INFO: mickey.zak.nl,mickey Zak,NL,ADMIN TIME : 15/08/2018 14:26:54 OPERATION : WOA APRROVED ,DATABASE psyche DATA RECEIVED : ----------------------------------------------------------------------------------------------------- USER INFO: mickey.zak.nl,mickey Zak,NL,ADMIN TIME : 15/08/2018 14:26:54 OPERATION : WOA APRROVED ,DATABASE psyche DATA RECEIVED : ----------------------------------------------------------------------------------------------------- ... and have 3 fields "USER INFO","TIME","OPERATION". So my regex have to process a string beginnig with a line of "-" and ending with a line of "-" I try lot of regex which work fine with java regex, python regex or ruby regex but none of them works with hive, for sample I tried this: CREATE EXTERNAL TABLE `auditpsyche_regex`( `userinfo` string COMMENT '', `time` string COMMENT '', `operation` string COMMENT '')ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.RegexSerDe'WITH SERDEPROPERTIES ("input.regex"="(?:.*\\n)?.*INFO: (.*)\\n.*TIME : (../../.... ..:..:..)\\n.*OPERATION : (.*)(?:.*\\s+)*?-----------------------------------------------------------------------------------------------------")LOCATION '/appli/psyche/log/auditpsyche'; But it doesn't work, I can find regex which works well line by line but not mutliline by multiline. I also tried a very simple regex like 'USER INFO : (.*)\n(.*)' to create a table with two field just to see if it can take multi line but not. How can I manage to create my hive table? ... View more