Member since
04-19-2017
5
Posts
0
Kudos Received
0
Solutions
06-14-2017
07:39 AM
How can I achieve this as I am getting data in JSON format and change in the column name does not read the field data with 'org.openx.data.jsonserde.JsonSerDe' parser.
... View more
06-07-2017
10:35 AM
Hi, I am able to create a table having column name with white spaces. CREATE EXTERNAL TABLE IF NOT EXISTS EXT_MILOGS(`Country of Visits` string); But when I try same thing with struct datatype CREATE EXTERNAL TABLE IF NOT EXISTS EXT_MILOGS(dimensions struct<`Country of Visits`: string>); I am not able to create the same. Am I missing something here? Thanks, Amol
... View more
- Tags:
- Data Processing
- Hive
Labels:
- Labels:
-
Apache Hive
05-05-2017
07:26 AM
hive> SELECT reflect('org.apache.commons.codec.digest.DigestUtils', 'md5Hex', '9SH305EIT');
OK
e9b9227eb2983499216f76b75e5233de
SELECT reflect('org.apache.commons.codec.digest.DigestUtils', 'md5Hex', col1) from table1 ;
OK
Failed with exception java.io.IOException:org.apache.hadoop.hive.ql.metadata.HiveException: UDFReflect getMethod
... View more
- Tags:
- Data Processing
- Upgrade to HDP 2.5.3 : ConcurrentModificationException When Executing Insert Overwrite : Hive
Labels:
- Labels:
-
Apache Hadoop
-
Apache Hive
05-03-2017
06:26 AM
select hash ('9SH305EJ5'); OK -339500666 select hash ('9SH305EIT'); OK -339500666
... View more