Re: Business Rules Engine for Hive

2018-04-16 Thread Al Pivonka
I am not the product owner an have not implemented it yet. I would check out http://cask.co/products/rules-engine/ On Mon, Apr 16, 2018 at 11:59 AM, Joel D wrote: > Hi, > > Any suggestions on how to implement Business Rules Engine with Hive ETLs? > > For spark based Etl jobs, I was exploring Dro

Re: Can one classify Hive as an analytical tool besides storage?

2017-08-14 Thread Al Pivonka
https://hadoopecosystemtable.github.io/ On Mon, Aug 14, 2017 at 12:36 PM, Mich Talebzadeh wrote: > This may be rather mute point. > > We had a discussion in the office about Hive and Impala! > > A colleague insisted that Hive and Impala are storage tools. Changed his > mind when I mentioned that

Re: Permission denied with select *

2016-05-30 Thread Al Pivonka
Access control lists... Who owns the system, database, tables, & files? Not only owner, but also do you belong to the group? What are the permissions on the files behind the table? Is Sentry enabled? On May 30, 2016 9:52 AM, "kishore kumar" wrote: Hi, If i run "select * from table" permission

Re: Unable to pick data from subdirectories into hive table in CDH 5.3.3

2016-05-19 Thread Al Pivonka
Read about hive partitions and bucketing. Since your location has multiple directories, Hive needs to know how to traverse them.. Hope this helps. On May 19, 2016 5:51 AM, "Abhishek Dubey" wrote: > Hi, > > > > In hdfs I have a directory structure like this. > > /user/hdfs/Data/Data1/File1 > > /u

Re: How does this work

2015-12-23 Thread Al Pivonka
Sentry sets up acls (access control list) on those directies, depending on who you granted access to when you established the tables location. Be careful to remove grant permissions when you drop the table or sentry will enforce the acls on the directory tree. Hope this helps On Dec 23, 2015 11:1

Re:

2015-03-25 Thread Al Pivonka
Why Who's emailing you On Mar 25, 2015 6:59 PM, "Alan Gates" wrote: > If you want off of the list send email to user-unsubscr...@hive.apache.org > > Alan. > > jake lawson > March 25, 2015 at 15:45 > Stop emailing me > >

Re: JDBX Web based sql viewers

2014-12-11 Thread Al Pivonka
Hue On Thu, Dec 11, 2014 at 8:54 AM, peterm_second wrote: > Hi Guys, > Do you know of any web based jdbc enabled sql viewers ? > > Peter > -- Those who say it can't be done, are usually interrupted by those doing it.

NULL DEFINED AS

2014-10-07 Thread Al Pivonka
I see there is a "NULL DEFINED AS" on row_format for a table. Is there a way to set "NULL DEFINED AS" at a database level? This would make maintenance much easier and less human error yet the table ""NULL DEFINED AS" on the row_format would out weigh the database setting for the table in question.