Re: Hive Presentions & Version related information

AFAIK nobody has been updating the Hive presentations. (Do I hear a volunteer?) The JIRA lists for Hive releases can be found by following links on the Downloads page . If you need information about a release that isn't on that page just click on any of the

Hive Presentions & Version related information

Hi I see a good number of presentations oh Hive in the wiki as below, https://cwiki.apache.org/confluence/display/Hive/Presentations#Presentations-RelatedWork But seems like there is no update for the presentations or materials in 2014. Is anybody maintaining it or it moved to a different locatio

Re: Errors while creating a new table using existing table schema

And now it's documented in the DDL wiki: - Use Database - Create Table (notes aft

Re: Errors while creating a new table using existing table schema

André, thanks for the reminder about USE , which hadn't been documented in the wiki. I've added a note to the Select Syntax section (for starters). -- Lefty On Sat, Jul 19, 2014 at 4:52 AM

Re: Errors while creating a new table using existing table schema

Hi Vidya, I believe you need to remove Location '/user/hive/warehouse/default.db/jobs_ex2' line since it stores the table automatically in warehouse once you create the table. On Sat, Jul 19, 2014 at 1:46 AM, Andre Araujo wrote: > Vidya, > > I'm not sure I've understood your problem correctly.

Re: Errors while creating a new table using existing table schema

Vidya, I'm not sure I've understood your problem correctly. But if you want to create a table in the default database you can do either: use default; create table jobs_ex2 as select ... OR create table default.jobs_ex2 as select ... With that you don't need to specify the LOCATION clause. Howe

Help on restricting users

Hi, I would like to restrict users doing "select * from table;" when accessed from any jdbc/odbc tools like sql workbench/excel etc.. connecting to hiveserver2 on port 1. I am able to successfully restrict users from running mapreduce jobs like "select count(*) from table" by changing permissi

Re: Errors while creating a new table using existing table schema

> > Hello, > > I am trying to create a new table using an existing table's schema > (existing table name in hive: jobs). However, when I do that it doesn't put > the new table (new table name in hive: jobs_ex2) in the same location as > the existing table. When I specify the location explicitly, it