Re: Hive - how to skip empty inner fields

Lukas, This is more of a data modelling request. Can you create a staging table which will source all relevant data (on important columns) you desire to query and nothing more than that. It would be more of a redundant job to add a NON NULL clause to subsequent queries, which is not a great desig

Re: External Table without Location

This is not a bug. If you do not explicitly specify location for a table, it will use the default database. -- Thanks, Raunak Jhawar m: 09820890034 On Fri, Mar 27, 2015 at 5:04 PM, Parth Anand wrote: > Hi, > > I was trying to create External table in hive. > > > I use

Re: Discrepancy in String matching between Teradata and HIVE

ct if('ABC' == rtrim('ABC '), 1,0); This would return 0: select if('ABC' == 'ABC ', 1,0); -- Thanks, Raunak Jhawar On Fri, Mar 27, 2015 at 2:11 PM, @Sanjiv Singh wrote: > Hi, > > I can use rtrim function, i.e: > > select id,name,CONCA

Re: how to set column level privileges

Adding my thoughts here... Both Apache Sentry and Apache ranger would not offer you column level fine grained security. Perhaps, as suggested by one member, creating views is more meaningful -- Thanks, Raunak Jhawar On Thu, Mar 26, 2015 at 8:53 PM, Alan Gates wrote: > Column le

Date conversion in Hive

local time zone in Hive) select created_at, > >unix_timestamp(created_at,"EE MMM dd HH:mm:ss "), > >from_unixtime(unix_timestamp(created_at,"EE MMM dd HH:mm:ss >> ")) > > from twitter_data limit 10; > > -- Thanks, Raunak Jhawar

Re: insert table error

Hi, The INSERT INTO ... VALUES syntax is not supported in Hive 0.13. This is a feature beyond Hive 0.14 only. -- Thanks, Raunak Jhawar On Tue, Mar 17, 2015 at 8:23 AM, 张奇迹 wrote: > thanks, it's the version's problem ,i am using 0.13.1 > > --

Re: insert table error

What version of Hive are you using. INSERT INTO ... VALUES is supported only from Hive 0.14 onwards. https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DML#LanguageManualDML-InsertingvaluesintotablesfromSQL -- Thanks, Raunak Jhawar m: 09820890034 On Fri, Mar 13, 2015 at 4:45

Re: FW: Hive error while starting up services using Ambari

Can you verify whether you can access hive metastore (hive database created on your mysql instance) with the given credentials. -- Thanks, Raunak Jhawar m: 09820890034 On Wed, Mar 11, 2015 at 12:52 PM, Pratik Gadiya < pratik_gad...@persistent.com> wrote: > Hi Srinivas, > &

Re: maximum number of tables and maximum number of partitions

Hi Anish, There is no ideal limit on number of tables that can be created as this number is relative to your disk capacity -- Thanks, Raunak Jhawar m: 09820890034 On Mon, Feb 23, 2015 at 5:23 AM, Anish Kejariwal wrote: > I'm using hive 0.13. What are the maximum number of hiv