You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Grandl Robert <rg...@yahoo.com> on 2014/09/18 00:44:35 UTC

run tpcds queries

Hi guys, 


A slightly off-topic question, but not sure where to ask. Have you ever ran TPC-DS queries over Tez ? If yes, do they work using tpcds_text_* databases as well ?

Running tpch- queries work fine over tpch_text_* databases, but it looks like tpcds- queries works only when using ORC databases. 

Is this true, or do I miss anything in configuring properly ?

Thanks a lot,
Robert

RE: run tpcds queries

Posted by Bikas Saha <bi...@hortonworks.com>.
Probably a question for hive user/dev mailing lists.



*From:* Grandl Robert [mailto:rgrandl@yahoo.com]
*Sent:* Wednesday, September 17, 2014 4:00 PM
*To:* user@tez.apache.org; user@hive.apache.org; Grandl Robert
*Subject:* Re: run tpcds queries



Hmm. It seems that the problem is some columns does not exist in tpcds_text
DB, so it requires to rename them accordingly.



Is this the case and the right fix ?



On Wednesday, September 17, 2014 3:45 PM, Grandl Robert <rg...@yahoo.com>
wrote:



Hi guys,



A slightly off-topic question, but not sure where to ask. Have you ever ran
TPC-DS queries over Tez ? If yes, do they work using tpcds_text_* databases
as well ?



Running tpch- queries work fine over tpch_text_* databases, but it looks
like tpcds- queries works only when using ORC databases.

Is this true, or do I miss anything in configuring properly ?



Thanks a lot,

Robert

-- 
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: run tpcds queries

Posted by Bikas Saha <bi...@hortonworks.com>.
Probably a question for hive user/dev mailing lists.



*From:* Grandl Robert [mailto:rgrandl@yahoo.com]
*Sent:* Wednesday, September 17, 2014 4:00 PM
*To:* user@tez.apache.org; user@hive.apache.org; Grandl Robert
*Subject:* Re: run tpcds queries



Hmm. It seems that the problem is some columns does not exist in tpcds_text
DB, so it requires to rename them accordingly.



Is this the case and the right fix ?



On Wednesday, September 17, 2014 3:45 PM, Grandl Robert <rg...@yahoo.com>
wrote:



Hi guys,



A slightly off-topic question, but not sure where to ask. Have you ever ran
TPC-DS queries over Tez ? If yes, do they work using tpcds_text_* databases
as well ?



Running tpch- queries work fine over tpch_text_* databases, but it looks
like tpcds- queries works only when using ORC databases.

Is this true, or do I miss anything in configuring properly ?



Thanks a lot,

Robert

-- 
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: run tpcds queries

Posted by Grandl Robert <rg...@yahoo.com>.
Hmm. It seems that the problem is some columns does not exist in tpcds_text DB, so it requires to rename them accordingly. 


Is this the case and the right fix ?



On Wednesday, September 17, 2014 3:45 PM, Grandl Robert <rg...@yahoo.com> wrote:
 


Hi guys, 


A slightly off-topic question, but not sure where to ask. Have you ever ran TPC-DS queries over Tez ? If yes, do they work using tpcds_text_* databases as well ?

Running tpch- queries work fine over tpch_text_* databases, but it looks like tpcds- queries works only when using ORC databases. 

Is this true, or do I miss anything in configuring properly ?

Thanks a lot,
Robert

Re: run tpcds queries

Posted by Grandl Robert <rg...@yahoo.com>.
Hmm. It seems that the problem is some columns does not exist in tpcds_text DB, so it requires to rename them accordingly. 


Is this the case and the right fix ?



On Wednesday, September 17, 2014 3:45 PM, Grandl Robert <rg...@yahoo.com> wrote:
 


Hi guys, 


A slightly off-topic question, but not sure where to ask. Have you ever ran TPC-DS queries over Tez ? If yes, do they work using tpcds_text_* databases as well ?

Running tpch- queries work fine over tpch_text_* databases, but it looks like tpcds- queries works only when using ORC databases. 

Is this true, or do I miss anything in configuring properly ?

Thanks a lot,
Robert