Styjun

...and then she held the gun

How would Japanese people react to someone refusing to say “itadakimasu” for religious reasons?

Query nodes and attributes of parent ways

What is the precise meaning of "подсел на мак"?

How can I ping multiple IP addresses at the same time?

Operator currying: how to convert f[a,b][c,d] to a+c,b+d?

I just entered the USA without passport control at Atlanta airport

Can you place a web spell on a surface you cannot see?

Bash function: Execute $@ command with each argument in sequence executed separately

How to sort human readable size

King or Queen-Which piece is which?

Should I email my professor to clear up a (possibly very irrelevant) awkward misunderstanding?

How can I detect if I'm in a subshell?

How do credit card companies know what type of business I'm paying for?

What are the mechanical differences between Adapt and Monstrosity?

Do details of my undergraduate title matter?

Can a character with the Polearm Master feat make an opportunity attack against an invisible creature that enters their reach?

What is this airplane that sits in front of Barringer High School in Newark, NJ?

Why do you need to heat the pan before heating the olive oil?

When is the phrase "j'ai bon" used?

How much steel armor can you wear and still be able to swim?

Why can't I craft scaffolding in Minecraft 1.14?

Fill the maze with a wall-following Snake until it gets stuck

Got a new frameset, don't know why I need this split ring collar?

Reflect api in hive failed while using it in beeline

Difference between Pig and Hive? Why have both?Oozie hive action failsHow to capture a hive exit status or error code using JDBC APIHive Macros/UDFs - Parallel/combined/single interpreterUnable to connect to HIVE through JDBC from a webappIn HIVE, what gives best performance when joining 2 tables on 4 columns? key column type String, Int or binary?Hive Full Table Scan Issue (Partitioned Columns Used)How to resolve broken pipe issue in Hive streaming with Python?Hive query fails in spark, but works in beeline HiveFailed to execute goal org.apache.maven.plugins:maven-surefire-plugin:2.18.1:test (default-test) on project hive-exec: There are test failures

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

0

I have a requirement to generate unique if for each and every record in hive.I have used the reflect api available in hive.The query works fine while using from hive command prompt but fails while using it from beeline(jdbc connector). It seems reflect api has been blacklisted and cant be used in beeline.

Kindly let me know if I can use the reflect api in any way to resolve the above issue and as I have already generated a set of unique id, I cant change the generated id, as its already been used in my project.

Query used:

insert into table abc select
reflect('org.apache.commons.codec.digest.DigestUtils', 'sha256Hex',concat(id,CTR,COD,YEAR,ITEM,DOC,CALYEAR)) as Unique_Id

hive oozie reflect

share|improve this question

edited Mar 25 at 4:45

Suraj Kumar

2,82951126

asked Mar 25 at 4:38

N BeheraN Behera

11

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Is there a way to "white-list" specific JARs in HiveServer2 conf? Do you have Sentry or Ranger in your cluster, with cystom security policies? Now you have to do your own research & debugging; good luck...
  
  – Samson Scharfrichter
  Mar 28 at 19:11
  

  
  
  
  

add a comment | 

0

I have a requirement to generate unique if for each and every record in hive.I have used the reflect api available in hive.The query works fine while using from hive command prompt but fails while using it from beeline(jdbc connector). It seems reflect api has been blacklisted and cant be used in beeline.

Kindly let me know if I can use the reflect api in any way to resolve the above issue and as I have already generated a set of unique id, I cant change the generated id, as its already been used in my project.

Query used:

insert into table abc select
reflect('org.apache.commons.codec.digest.DigestUtils', 'sha256Hex',concat(id,CTR,COD,YEAR,ITEM,DOC,CALYEAR)) as Unique_Id

hive oozie reflect

share|improve this question

edited Mar 25 at 4:45

Suraj Kumar

2,82951126

asked Mar 25 at 4:38

N BeheraN Behera

11

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Is there a way to "white-list" specific JARs in HiveServer2 conf? Do you have Sentry or Ranger in your cluster, with cystom security policies? Now you have to do your own research & debugging; good luck...
  
  – Samson Scharfrichter
  Mar 28 at 19:11
  

  
  
  
  

add a comment | 

I have a requirement to generate unique if for each and every record in hive.I have used the reflect api available in hive.The query works fine while using from hive command prompt but fails while using it from beeline(jdbc connector). It seems reflect api has been blacklisted and cant be used in beeline.

Kindly let me know if I can use the reflect api in any way to resolve the above issue and as I have already generated a set of unique id, I cant change the generated id, as its already been used in my project.

Query used:

insert into table abc select
reflect('org.apache.commons.codec.digest.DigestUtils', 'sha256Hex',concat(id,CTR,COD,YEAR,ITEM,DOC,CALYEAR)) as Unique_Id

hive oozie reflect

share|improve this question

edited Mar 25 at 4:45

Suraj Kumar

2,82951126

asked Mar 25 at 4:38

N BeheraN Behera

11

insert into table abc select
reflect('org.apache.commons.codec.digest.DigestUtils', 'sha256Hex',concat(id,CTR,COD,YEAR,ITEM,DOC,CALYEAR)) as Unique_Id

share|improve this question

edited Mar 25 at 4:45

Suraj Kumar

2,82951126

asked Mar 25 at 4:38

N BeheraN Behera

11

share|improve this question

edited Mar 25 at 4:45

Suraj Kumar

2,82951126

asked Mar 25 at 4:38

N BeheraN Behera

11

edited Mar 25 at 4:45

Suraj Kumar

2,82951126

edited Mar 25 at 4:45

Suraj Kumar

2,82951126

asked Mar 25 at 4:38

N BeheraN Behera

11

asked Mar 25 at 4:38

N BeheraN Behera

11