Re: Top N query

I does't understand about your solution. Could you please provide exact query? ... GROUP BY recommend_ratings2.movieid ORDER BY Measure_0 DESC limit 2 ) T_0 ON ( recommend_ratings2.movieid = T_0.movieid_0) Follow the docs on the mysql impl of the space-ship operator -

Re: When using ORC, how to confirm Stipes/row-groups are being skipped ?

Hi, While using ORC file format, I would like to see in the logs that stripes and/or row-groups are being skipped based on my where clause. There¹s no logging in the inner loop there. Is that info even outputted ? If so, what do I need to enable it ? You can do a query run with the following

Row number

Hi everyone, I need to find row number using hive query. Could you please help any way to find row number? It is the sample sql query select row_number() over (partition by NAME order by PRICE) as RANK, NAME, PRICEfrom MY_TABLE; Regards, Ravisankar

Exception in thread main java.lang.RuntimeException: java.io.IOException: Previous writer likely failed to write hdfs://localhost:8020/tmp/hive/hadoop/_tez_session_dir/39ba9c15-d9ed-4582-a4ce-11ae8b

I am using *hive 1.0.0* and *apache tez 0.5.2* When I configure hive to use tez I get an exception. In *hive-site.xml* when the *hive.execution.engine* value is mr its works fine. But if I set it to tez I get this error: Exception in thread main java.lang.RuntimeException: java.io.IOException:

Re: Create ORC Table on Tez Failed

Hi, If you are table name is orc_table in the exception i can see the table name as test Moving data to: hdfs://namenode:8020/apps/hive/warehouse/test Failed with exception Unable to rename:

Re: HiveMetaStoreClient error

What is the error, can you add here.. On Thu, Jun 4, 2015 at 3:51 PM, Ankita Jhar ankitajharut...@gmail.com wrote: Hi, I attempted to configure the remote metastore I hive which did not succeed , so I reverted hive-site.XML settings to the previous ones ...now whenever I make any new

create statement in hive 1.0.0.

anyone help me please... how to write insert statement in hive 1.0.0?

Create ORC Table on Tez Failed

Hi, We are trying to create a Hive ORC Table with Tez. DDL command for the same is create table orc_table ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' LINES TERMINATED BY '\n' STORED AS ORC AS select * from select_table; However, it fails with the following error message:

Re: Create ORC Table on Tez Failed

I would look in the hive server log, as well as the name node log. That should have a full stack trace. On Jun 4, 2015, at 4:13 AM, Vijay Bhoomireddy vijaya.bhoomire...@whishworks.com wrote: Hi, We are trying to create a Hive ORC Table with Tez. DDL command for the same is

Hiveserver2 stops logging

Hi Folks, We are experiencing an issue with Hive that we have not been able to solve for few weeks. Hiveserver2 stops logging with no error messages in the log but continues to process normally but after few hours or a day, hive crashes. When I restart hive, processing is normal and it

Re: Hiveserver2 stops logging

Hi, What version you are using and what is the environment.. On Thu, Jun 4, 2015 at 2:35 PM, Palani, MuthuKumar A muthu.ku...@firstdata.com wrote: Hi Folks, We are experiencing an issue with Hive that we have not been able to solve for few weeks. Hiveserver2 stops logging with no

HiveMetaStoreClient error

Hi, I attempted to configure the remote metastore I hive which did not succeed , so I reverted hive-site.XML settings to the previous ones ...now whenever I make any new changes to hive-site.XML I get the error for HiveMetaStoreClient ) . I do some workarounds but don't understand the reason

Re: create statement in hive 1.0.0.

Please check Hive Language Manual https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DML Hope It Helps, Chinna On Thu, Jun 4, 2015 at 4:28 PM, Sateesh Karuturi sateesh.karutu...@gmail.com wrote: anyone help me please... how to write insert statement in hive 1.0.0? -- Hope