Is there any difference between count(*) and count(1) in Hive. And which
one should we use in general and why?
Given that I am on Hive 0.6 version.
*Raihan Jamal*
is- How to get the Yesterdays date which I can use
on the Date Partition I cannot use hiveconf here as I am working with Hive
0.6
*Raihan Jamal*
On Tue, Aug 7, 2012 at 10:37 AM, Jan Dolinár wrote:
> I'm afraid that he query
>
> SELECT * FROM REALTIME where dt= yesterday
DEPENDENCIES:
Stage-0 is a root stage
STAGE PLANS:
Stage: Stage-0
Fetch Operator
limit: 5
Time taken: 12.126 seconds
*Raihan Jamal*
On Tue, Aug 7, 2012 at 10:56 AM, Jan Dolinár wrote:
> Oops, sorry I made a copy&paste mistake :) The annotation should read
806’ LIMIT 10;
So that means it will look for data in the corresponding dt partition
*(20120806)
*only right as above table is partitioned on dt column ? And it will not
scan the whole table right?**
*Raihan Jamal*
On Mon, Aug 6, 2012 at 10:56 PM, Jan Dolinár wrote:
> Hi Jamal,
>
ng is wrong the way I am doing it for sure?
*Raihan Jamal*
On Mon, Aug 6, 2012 at 10:56 PM, Jan Dolinár wrote:
> Hi Jamal,
>
> Check if the function really returns what it should and that your data are
> really in MMdd format. You can do this by simple query like this:
>
*Problem*
I created the below UserDefinedFunction to get the yesterday's day in the
format I wanted as I will be passing the format into this below method from
the query.
*public final class YesterdayDate extends UDF {*
* *
*public String evaluate(final String format) { *
*
[
https://issues.apache.org/jira/browse/HIVE-3233?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Raihan Jamal updated HIVE-3233:
---
Priority: Major (was: Minor)
> Error in semantic analysis:Invalid Table Al
Does anyone is aware of Hive variable substitution works in Hive 0.6 or not?
*Raihan Jamal*
Raihan Jamal created HIVE-3233:
--
Summary: Error in semantic analysis:Invalid Table Alias
Key: HIVE-3233
URL: https://issues.apache.org/jira/browse/HIVE-3233
Project: Hive
Issue Type: Bug
You mean by the use of HIVE-3100 I can connect to Hive using some web
interface vid jdbc? Can you provide me links or tutorials where I can
achieve this?
*Raihan Jamal*
On Sun, Jul 1, 2012 at 10:51 PM, Prasad Mujumdar wrote:
>Check HIVE-3100 which is to include SQLLine as command l
short my question is- Can I do the same thing in any SQLClient
> instead of logging from the Putty?**
>
>
> -Raihan Jamal
>
short my question is- Can I do the same thing in any SQLClient
> instead of logging from the Putty?**
>
>
> -Raihan Jamal
>
12 matches
Mail list logo
