Re: Exception in Hive with SMB join and Parquet

2014-07-30 Thread Suma Shivaprasad
Retried with hive.optimize.sort.dynamic.partition=false. Still seeing the same issue. Thanks Suma On Wed, Jul 30, 2014 at 6:55 PM, Nitin Pawar wrote: > what's the value of the variable hive.optimize.sort.dynamic.partition > > can you try disabling it if it on? > > > On Wed, Jul 30, 2014 at 6:4

Re: Exception in Hive with SMB join and Parquet

2014-07-30 Thread Nitin Pawar
what's the value of the variable hive.optimize.sort.dynamic.partition can you try disabling it if it on? On Wed, Jul 30, 2014 at 6:43 PM, Suma Shivaprasad < sumasai.shivapra...@gmail.com> wrote: > Am using 0.13.0 version of hive with parquet table having 34 columns with the > following props w

Exception in Hive with SMB join and Parquet

2014-07-30 Thread Suma Shivaprasad
Am using 0.13.0 version of hive with parquet table having 34 columns with the following props while creating the table *CLUSTERED BY (udid) SORTED BY (udid ASC) INTO 256 BUCKETS STORED as PARQUET TBLPROPERTIES ("parquet.compression"="SNAPPY"); * The query I am running is *set hive.optimize.bu