You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by Xuefu Zhang <xz...@cloudera.com> on 2014/05/13 02:45:49 UTC
showing column stats
Hi all,
I'm wondering if there is a simpler way to show column stats than writing a
thrift client calling the thrift API, such as commands in Hive CLI. I have
tried "desc extended" as well as "explain select", but none of them shows
column stats.
Thanks,
Xuefu
Re: showing column stats
Posted by Xuefu Zhang <xz...@cloudera.com>.
Thanks, Prasanth. I tried your patch in HIVE-7050, and it helped me
demonstrate another problem related to stats, HIVE-7053.
I can review your patches. Thanks again!
--Xuefu
On Mon, May 12, 2014 at 6:57 PM, Prasanth Jayachandran <
pjayachandran@hortonworks.com> wrote:
> Create the JIRAs
> https://issues.apache.org/jira/browse/HIVE-7050
> https://issues.apache.org/jira/browse/HIVE-7051
>
> Thanks
> Prasanth Jayachandran
>
> On May 12, 2014, at 6:52 PM, Prasanth Jayachandran <
> pjayachandran@hortonworks.com> wrote:
>
> > I have a basic patch which prints table level column stats.. I can put
> up the patch for it today/tomorrow.. but for displaying partition level
> column stats we need to extend the “describe” statement to support column
> names..
> >
> https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-DescribePartition.
> If you see the DDL describe partition does not accept column names.
> >
> > I can create JIRAs for the following tasks
> > 1) Showing column stats in describe table
> > 2) Showing column stats in describe partition
> >
> > If you would like to take up 2) please feel free to do so.
> >
> > Thanks
> > Prasanth Jayachandran
> >
> > On May 12, 2014, at 5:45 PM, Xuefu Zhang <xz...@cloudera.com> wrote:
> >
> >> Hi all,
> >>
> >> I'm wondering if there is a simpler way to show column stats than
> writing a
> >> thrift client calling the thrift API, such as commands in Hive CLI. I
> have
> >> tried "desc extended" as well as "explain select", but none of them
> shows
> >> column stats.
> >>
> >> Thanks,
> >> Xuefu
> >
>
>
> --
> CONFIDENTIALITY NOTICE
> NOTICE: This message is intended for the use of the individual or entity to
> which it is addressed and may contain information that is confidential,
> privileged and exempt from disclosure under applicable law. If the reader
> of this message is not the intended recipient, you are hereby notified that
> any printing, copying, dissemination, distribution, disclosure or
> forwarding of this communication is strictly prohibited. If you have
> received this communication in error, please contact the sender immediately
> and delete it from your system. Thank You.
>
Re: showing column stats
Posted by Prasanth Jayachandran <pj...@hortonworks.com>.
Create the JIRAs
https://issues.apache.org/jira/browse/HIVE-7050
https://issues.apache.org/jira/browse/HIVE-7051
Thanks
Prasanth Jayachandran
On May 12, 2014, at 6:52 PM, Prasanth Jayachandran <pj...@hortonworks.com> wrote:
> I have a basic patch which prints table level column stats.. I can put up the patch for it today/tomorrow.. but for displaying partition level column stats we need to extend the “describe” statement to support column names..
> https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-DescribePartition. If you see the DDL describe partition does not accept column names.
>
> I can create JIRAs for the following tasks
> 1) Showing column stats in describe table
> 2) Showing column stats in describe partition
>
> If you would like to take up 2) please feel free to do so.
>
> Thanks
> Prasanth Jayachandran
>
> On May 12, 2014, at 5:45 PM, Xuefu Zhang <xz...@cloudera.com> wrote:
>
>> Hi all,
>>
>> I'm wondering if there is a simpler way to show column stats than writing a
>> thrift client calling the thrift API, such as commands in Hive CLI. I have
>> tried "desc extended" as well as "explain select", but none of them shows
>> column stats.
>>
>> Thanks,
>> Xuefu
>
--
CONFIDENTIALITY NOTICE
NOTICE: This message is intended for the use of the individual or entity to
which it is addressed and may contain information that is confidential,
privileged and exempt from disclosure under applicable law. If the reader
of this message is not the intended recipient, you are hereby notified that
any printing, copying, dissemination, distribution, disclosure or
forwarding of this communication is strictly prohibited. If you have
received this communication in error, please contact the sender immediately
and delete it from your system. Thank You.
Re: showing column stats
Posted by Prasanth Jayachandran <pj...@hortonworks.com>.
I have a basic patch which prints table level column stats.. I can put up the patch for it today/tomorrow.. but for displaying partition level column stats we need to extend the “describe” statement to support column names..
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-DescribePartition. If you see the DDL describe partition does not accept column names.
I can create JIRAs for the following tasks
1) Showing column stats in describe table
2) Showing column stats in describe partition
If you would like to take up 2) please feel free to do so.
Thanks
Prasanth Jayachandran
On May 12, 2014, at 5:45 PM, Xuefu Zhang <xz...@cloudera.com> wrote:
> Hi all,
>
> I'm wondering if there is a simpler way to show column stats than writing a
> thrift client calling the thrift API, such as commands in Hive CLI. I have
> tried "desc extended" as well as "explain select", but none of them shows
> column stats.
>
> Thanks,
> Xuefu
--
CONFIDENTIALITY NOTICE
NOTICE: This message is intended for the use of the individual or entity to
which it is addressed and may contain information that is confidential,
privileged and exempt from disclosure under applicable law. If the reader
of this message is not the intended recipient, you are hereby notified that
any printing, copying, dissemination, distribution, disclosure or
forwarding of this communication is strictly prohibited. If you have
received this communication in error, please contact the sender immediately
and delete it from your system. Thank You.