Hi:All
I have a such problem,in jdbcclient,issuing the query "select * from
accesslog" ,the columns of results is right

host            callingid             .......
 **                  ***                   **
 **                  **                    **
but when issuing query "select host from accesslog " ,the columns of the
result is wrong:

_col0
**
**
**
i search the source code ,and found that the meta data of ResultSet is from
the fetchtask of the query plan,  and is the schema of
a temporary table.
How can i get the right columns of the result? any suggestions will be
appreciated.Thanks advance.
--
Best Regards
Anty Rao

HIVE-763 <https://issues.apache.org/jira/browse/HIVE-763> is exactly the
same with my problem, does anyone working on this?

On Mon, Jan 25, 2010 at 3:32 PM, Anty <[EMAIL PROTECTED]> wrote:

> Hi:All
> I have a such problem,in jdbcclient,issuing the query "select * from
> accesslog" ,the columns of results is right
>
> host            callingid             .......
>  **                  ***                   **
>  **                  **                    **
>
>
> but when issuing query "select host from accesslog " ,the columns of the
> result is wrong:
>
> _col0
> **
> **
> **
> i search the source code ,and found that the meta data of ResultSet is from
> the fetchtask of the query plan,  and is the schema of
> a temporary table.
> How can i get the right columns of the result? any suggestions will be
> appreciated.Thanks advance.
> --
> Best Regards
> Anty Rao
>

--
Best Regards
Anty Rao

While working on CREATE VIEW support recently, I noticed this and added a new internal method which should make it easy to fix this.  I'll comment on HIVE-763 and submit a patch for it.

JVS

On Jan 25, 2010, at 6:46 AM, Anty wrote:

HIVE-763<https://issues.apache.org/jira/browse/HIVE-763> is exactly the same with my problem, does anyone working on this?

On Mon, Jan 25, 2010 at 3:32 PM, Anty <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>> wrote:
Hi:All
I have a such problem,in jdbcclient,issuing the query "select * from accesslog" ,the columns of results is right

host            callingid             .......
 **                  ***                   **
 **                  **                    **
but when issuing query "select host from accesslog " ,the columns of the result is wrong:

_col0
**
**
**
i search the source code ,and found that the meta data of ResultSet is from the fetchtask of the query plan,  and is the schema of
a temporary table.
How can i get the right columns of the result? any suggestions will be appreciated.Thanks advance.
--
Best Regards
Anty Rao

--
Best Regards
Anty Rao

Thanks John Sichi, I have tested the path, it works fine.Thanks very much.

On Tue, Jan 26, 2010 at 1:14 AM, John Sichi <[EMAIL PROTECTED]> wrote:

> While working on CREATE VIEW support recently, I noticed this and added a
> new internal method which should make it easy to fix this.  I'll comment on
> HIVE-763 and submit a patch for it.
>
> JVS
>
> On Jan 25, 2010, at 6:46 AM, Anty wrote:
>
> HIVE-763 <https://issues.apache.org/jira/browse/HIVE-763> is exactly the
> same with my problem, does anyone working on this?
>
> On Mon, Jan 25, 2010 at 3:32 PM, Anty <[EMAIL PROTECTED]> wrote:
>
>> Hi:All
>> I have a such problem,in jdbcclient,issuing the query "select * from
>> accesslog" ,the columns of results is right
>>
>> host            callingid             .......
>>  **                  ***                   **
>>  **                  **                    **
>>
>>
>> but when issuing query "select host from accesslog " ,the columns of the
>> result is wrong:
>>
>> _col0
>> **
>> **
>> **
>> i search the source code ,and found that the meta data of ResultSet is
>> from the fetchtask of the query plan,  and is the schema of
>> a temporary table.
>> How can i get the right columns of the result? any suggestions will be
>> appreciated.Thanks advance.
>> --
>> Best Regards
>> Anty Rao
>>
>
>
>
> --
> Best Regards
> Anty Rao
>
>
>
--
Best Regards
Anty Rao

The patch also works for me :) I think you just made a lot of people happy..

Anty wrote:
> Thanks John Sichi, I have tested the path, it works fine.Thanks very much.
>
> On Tue, Jan 26, 2010 at 1:14 AM, John Sichi <[EMAIL PROTECTED]
> <mailto:[EMAIL PROTECTED]>> wrote:
>
>     While working on CREATE VIEW support recently, I noticed this and
>     added a new internal method which should make it easy to fix this.
>      I'll comment on HIVE-763 and submit a patch for it.
>
>     JVS
>
>     On Jan 25, 2010, at 6:46 AM, Anty wrote:
>
>>     HIVE-763 <https://issues.apache.org/jira/browse/HIVE-763> is
>>     exactly the same with my problem, does anyone working on this?
>>
>>     On Mon, Jan 25, 2010 at 3:32 PM, Anty <[EMAIL PROTECTED]
>>     <mailto:[EMAIL PROTECTED]>> wrote:
>>
>>         Hi:All
>>         I have a such problem,in jdbcclient,issuing the query "select
>>         * from accesslog" ,the columns of results is right
>>
>>         host            callingid             .......
>>          **                  ***                   **
>>          **                  **                    **
>>
>>
>>         but when issuing query "select host from accesslog " ,the
>>         columns of the result is wrong:
>>
>>         _col0
>>         **
>>         **
>>         **
>>         i search the source code ,and found that the meta data of
>>         ResultSet is from the fetchtask of the query plan,  and is
>>         the schema of
>>         a temporary table.
>>         How can i get the right columns of the result? any
>>         suggestions will be appreciated.Thanks advance.
>>         --
>>         Best Regards
>>         Anty Rao
>>
>>
>>
>>
>>     --
>>     Best Regards
>>     Anty Rao
>
>
>
>
> --
> Best Regards
> Anty Rao

We aim to please :)

JVS

On Jan 26, 2010, at 5:22 AM, Bennie Schut wrote:

> The patch also works for me :) I think you just made a lot of people happy..
>
> Anty wrote:
>> Thanks John Sichi, I have tested the path, it works fine.Thanks very much.
>>
>> On Tue, Jan 26, 2010 at 1:14 AM, John Sichi <[EMAIL PROTECTED]
>> <mailto:[EMAIL PROTECTED]>> wrote:
>>
>>    While working on CREATE VIEW support recently, I noticed this and
>>    added a new internal method which should make it easy to fix this.
>>     I'll comment on HIVE-763 and submit a patch for it.
>>
>>    JVS
>>
>>    On Jan 25, 2010, at 6:46 AM, Anty wrote:
>>
>>>    HIVE-763 <https://issues.apache.org/jira/browse/HIVE-763> is
>>>    exactly the same with my problem, does anyone working on this?
>>>
>>>    On Mon, Jan 25, 2010 at 3:32 PM, Anty <[EMAIL PROTECTED]
>>>    <mailto:[EMAIL PROTECTED]>> wrote:
>>>
>>>        Hi:All
>>>        I have a such problem,in jdbcclient,issuing the query "select
>>>        * from accesslog" ,the columns of results is right
>>>
>>>        host            callingid             .......
>>>         **                  ***                   **
>>>         **                  **                    **
>>>
>>>
>>>        but when issuing query "select host from accesslog " ,the
>>>        columns of the result is wrong:
>>>
>>>        _col0
>>>        **
>>>        **
>>>        **
>>>        i search the source code ,and found that the meta data of
>>>        ResultSet is from the fetchtask of the query plan,  and is
>>>        the schema of
>>>        a temporary table.
>>>        How can i get the right columns of the result? any
>>>        suggestions will be appreciated.Thanks advance.
>>>        --
>>>        Best Regards
>>>        Anty Rao
>>>
>>>
>>>
>>>
>>>    --
>>>    Best Regards
>>>    Anty Rao
>>
>>
>>
>>
>> --
>> Best Regards
>> Anty Rao
>