Rajesh Balamohan created HIVE-27099:
---
Summary: Iceberg: select count(*) from table queries all data
Key: HIVE-27099
URL: https://issues.apache.org/jira/browse/HIVE-27099
Project: Hive
rely on those if needed
>>
>>
>> HTH
>>
>>
>>
>>
>> Dr Mich Talebzadeh
>>
>>
>>
>> LinkedIn *
>> https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
>> <https://www.linkedin.com/profile/view?id=AA
dOABUrV8Pw
> <https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>*
>
>
>
> http://talebzadehmich.wordpress.com
>
>
>
> On 22 March 2016 at 07:14, Amey Barve wrote:
>
>> select count(*) from table;
>>
>> How does hi
, Mar 22, 2016 at 12:44 PM, Amey Barve wrote:
> select count(*) from table;
>
> How does hive evaluate count(*) on a table?
>
> Does it return count by actually querying table, or directly return count
> by consulting some statistics locally.
>
> For Hive's Text form
select count(*) from table;
How does hive evaluate count(*) on a table?
Does it return count by actually querying table, or directly return count
by consulting some statistics locally.
For Hive's Text format it takes few seconds while Hive's Orc format takes
fraction of seconds.
Regards,
Amey
to reopen
if you are able to repro this on trunk.
> "select count(*) from table" query on hive-0.10.0, hbase-0.94.7 integration
> throws exceptions
> -
>
>
and see if we have any
resolution.
> "select count(*) from table" query on hive-0.10.0, hbase-0.94.7 integration
> throws exceptions
> -
>
> Key: HIVE-4515
hive release, probably due to some
incompatible dependencies. I wasn't able to reproduce this with apache stack.
As a side note for your avro support of HBase, you might as well look into the
patch on HIVE-6147. It attempts to solve the sam problem.
> "select count(*) from tab
for this. We are
using CDH 4.4.
Any suggestions?
> "select count(*) from table" query on hive-0.10.0, hbase-0.94.7 integration
> throws exceptions
> -
>
> Key: HI
successfully:
{noformat}
create table
insert overwrite table
select * from table
However, when execute "select count(*) from table", throws exception:
hive> select count(*) from test;
Total MapReduce jobs = 1
Launching Job 1 out of 1
Number of reduce tasks determined at compile time:
[
https://issues.apache.org/jira/browse/HIVE-4515?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Swarnim Kulkarni reassigned HIVE-4515:
--
Assignee: Swarnim Kulkarni
> "select count(*) from table" query on hive-
, or any other workaround for it.
I am stuck with it for a while.
> "select count(*) from table" query on hive-0.10.0, hbase-0.94.7 integration
> throws exceptions
> -
>
>
[
https://issues.apache.org/jira/browse/HIVE-4515?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Swarnim Kulkarni updated HIVE-4515:
---
Affects Version/s: 0.11.0
> "select count(*) from table" query on hive-
-1.0.4
centos-5.7
was:
hive-0.10.0
hbase-0.94.7
zookeeper-3.4.3
hadoop-1.0.4
centos-5.7
> "select count(*) from table" query on hive-0.10.0, hbase-0.94.7 integration
> t
[
https://issues.apache.org/jira/browse/HIVE-4515?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Yanhui Ma updated HIVE-4515:
Priority: Critical (was: Major)
> "select count(*) from table" query on hive-0.10.0,
Yanhui Ma created HIVE-4520:
---
Summary: "select count(*) from table" query on hive-0.10.0,
hbase-0.94.7 integration throws exceptions
Key: HIVE-4520
URL: https://issues.apache.org/jira/browse
Yanhui Ma created HIVE-4515:
---
Summary: "select count(*) from table" query on hive-0.10.0,
hbase-0.94.7 integration throws exceptions
Key: HIVE-4515
URL: https://issues.apache.org/jira/browse
17 matches
Mail list logo
