Re: Unable to access hive views

2018-08-21 Thread Tanvi Thacker
k*, but > no luck. > > > This is my stackoverflow link: > > > https://stackoverflow.com/questions/51664932/unable-to-access-hive-views > > Please help me out. > > >

Unable to access hive views

2018-08-02 Thread Satish Karuturi
, hive.execution.engine as *mr* and as well as *spark*, but no luck. This is my stackoverflow link: https://stackoverflow.com/questions/51664932/unable-to-access-hive-views Please help me out.

Re: Will partition pruning will happen on HIVE views?

2018-01-23 Thread Furcy Pin
Hi, I might be wrong, but I would expect views to work as a simple replacement at the query level (like a subquery or a CTE). This means that partition pruning should work as long as predicate pushdown properly works. For your specific use case, it should be easy enough to test, and you can use an

Will partition pruning will happen on HIVE views?

2018-01-23 Thread Ramasubramanian Narayanan
Hi, I have a scenario. Hive table "Table1" created with Partition with txn date. A view "VIEW_TABLE1" is created on top of "Table" with the query 'select * from table1'. If I query the view with the where clause using txn_date, will partition pruning happen? Please throw some light how it will

Re: BNF for Hive Views

2013-08-25 Thread Stephen Boesch
The antlr file (Hive.g ) is providing the info I need for this specific case, but if BNF exists a pointer would still be helpful . Thx 2013/8/25 Stephen Boesch > yes i had read and re-read it. I do have a specific reason for wishing > to view the bnf. thanks. > > > 2013/8/25 Lefty Leverenz

Re: BNF for Hive Views

2013-08-25 Thread Stephen Boesch
yes i had read and re-read it. I do have a specific reason for wishing to view the bnf. thanks. 2013/8/25 Lefty Leverenz > Have you tried the Views chapter in the O'Reilly book "Programming Hive" > by Rutherglen, Wampler, and Capriolo? > > -- Lefty > > > > On Mon, Aug 26, 2013 at 12:14 AM, St

Re: BNF for Hive Views

2013-08-25 Thread Lefty Leverenz
Have you tried the Views chapter in the O'Reilly book "Programming Hive" by Rutherglen, Wampler, and Capriolo? -- Lefty On Mon, Aug 26, 2013 at 12:14 AM, Stephen Boesch wrote: > I was already well familiar with the content of the links you provided. > I have a specific question about the BNF f

Re: BNF for Hive Views

2013-08-25 Thread Stephen Boesch
I was already well familiar with the content of the links you provided. I have a specific question about the BNF for views (and potentially other ddl/dml) that does not appear to be addressed . Thanks. 2013/8/25 Lefty Leverenz > Let me introduce you to the Hive wiki. > >- Hive wiki home

Re: BNF for Hive Views

2013-08-25 Thread Lefty Leverenz
Let me introduce you to the Hive wiki. - Hive wiki home page: https://cwiki.apache.org/confluence/display/Hive/Home - Language manual: https://cwiki.apache.org/confluence/display/Hive/LanguageManual - DDL: https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL - V

BNF for Hive Views

2013-08-25 Thread Stephen Boesch
It appears a bit challenging to find the BNF's for the hive DDL's. After a few google's the following popped up for cdh3 and only for a subset of table creation's. http://archive.cloudera.com/cdh/3/hive/language_manual/data-manipulation-statements.html Is there an updated and more complete DDL

Re: Hive views

2013-05-21 Thread Edward Capriolo
recreate your views. I > would try creating a script that has the create views the call that from > the startup script. > > Clay > > > -Original Message- > From: abhishek [mailto:abhishek.dod...@gmail.com] > Sent: Thursday, May 16, 2013 6:45 PM > To: cdh-u...@c

RE: Hive views

2013-05-21 Thread Clay McDonald
: cdh-u...@cloudera.org; Hive Subject: Hive views Hi all, We had created views in hive, but when we restart the cluster then the views created in the hive are deleted automatically. I know hive view doesn't persist after cluster restart, but I want figure it out a way to persist it. Can so

Hive views

2013-05-16 Thread abhishek
Hi all, We had created views in hive, but when we restart the cluster then the views created in the hive are deleted automatically. I know hive view doesn't persist after cluster restart, but I want figure it out a way to persist it. Can someone help me how to do that? Regards Abhishek