k*, but
> no luck.
>
>
> This is my stackoverflow link:
>
>
> https://stackoverflow.com/questions/51664932/unable-to-access-hive-views
>
> Please help me out.
>
>
>
, 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.
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
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
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
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
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
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
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
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
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
: 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
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
13 matches
Mail list logo