Confirm your subscription to Dedicated DB

Hello! Hurray! You've subscribed to our site. We need you to activate your subscription to the list(s): Dedicated DB Blog by clicking the link below: Click here to confirm your subscription. ( https://401k-db.com/?wysija-page=1=confirm=5229437e8943889b635f1c9b76e29840=subscribe=subscriptions

Re: MDX queries on kylin cubes.

Hi Prasanna & Team, Can you please suggest if you were able to access kylin cube using MDX queries? Thanks, Saurabh Sent from my iPhone, please avoid typos. > On 17-Jan-2018, at 10:06 AM, Prasanna wrote: > > Hi all, > > I am using kylin 2.2.0 version.

Re: Microstratergy Integration with Kylin

://kyligence.gitbooks.io/kap-manual/content/en/integration/microstrategy_10_4.en.html > > 2017-06-26 22:28 GMT+08:00 ShaoFeng Shi <shaofeng...@apache.org>: >> Microstrategy 10.x can connect with Kylin via the ODBC driver, you can take >> a try. We will have a document on

Re: Controlling Number of small files while inserting into Hive table

Hi Arpan, Include the partition column in the distribute by clause of DML, it will generate only one file per day. Hope this will resolve the issue. > "insert into 'target_table' select a,b,c from x where ... distribute by > (date)" > PS: Backdated processing will generate additional file(s).

Microstratergy Integration with Kylin

Hi All, Can you share if Microstratergy tool can be connected to Kylin? Tableau Integration is awesome however we are bound to microstratergy, any help is greatly appreciated. Thanks, Saurabh

Re: Hive update operation

Hi Mich, Nice explanation! The Update operation in hive work on row by row or it is performed in batches? We also observed multiple temp files getting generated in hdfs while performing the update operation. It will be really helpful if you can share details what hive does in the

Unsubscribe

Unsubscribe > On 06-Apr-2016, at 5:40 PM, Brian London wrote: > > unsubscribe - To unsubscribe, e-mail: user-unsubscr...@spark.apache.org For additional commands, e-mail: user-h...@spark.apache.org

Re: Bucketing- Identify Number of Buckets

Details of Hive Version: I am using Hive -14.0 with Tez as execution engine. Thanks, Saurabh Sent from my iPhone, please avoid typos. > On 07-Sep-2015, at 1:51 am, Db-Blog <mpp.databa...@gmail.com> wrote: > > Hi, > > I need to join two big tables in hive. The join key

Bucketing- Identify Number of Buckets

Hi, I need to join two big tables in hive. The join key is the grain of both these tables, hence clustering and sorting on the same will provide significant performance optimisation while joining. However, i am not sure how to calculate the exact number of buckets while creating these

Tez Optimisation Parameters

Hi, I am trying to load aggregate data from one massive table containing historical data of ONE year. Partitioning is implemented on the historical table, however the number of files huge (#100) and are gz compressed. When i trying to load it using Tez execution engine. Can someone suggest

Re: Handling blob in hive

You can store Blob data type as string in hive. Thanks, Saurabh Sent from my iPhone, please avoid typos. On 08-Aug-2014, at 9:10 am, Chhaya Vishwakarma chhaya.vishwaka...@lntinfotech.com wrote: Hi, I want to store and retrieve blob in hive.Is it possible to store blob in hive? If

Re: Hive huge 'startup time'

Hello everyone, Thanks for sharing valuable inputs. I am working on similar kind of task, it will be really helpful if you can share the command for increasing the heap size of hive-cli/launching process. Thanks, Saurabh Sent from my iPhone, please avoid typos. On 18-Jul-2014, at 8:23

Real time data processing on Hadoop WITHOUT Java

Hello Experts, I am new to real time processing of hadoop and storm too. I checked the implementation details provided over storm documentation however it seems to be all java coding. I'm a database guy and didn't work on java stuffs earlier. I have worked on Hive/Impala/Pig related things

Re: large small files vs one big file in hive table

In general it is recommended to have Millions of Large files rather than billions of small files in hadoop. Please describe your issues in detail. Say for ex. -How are you planning to consume the data stored in this partition table? - Are you looking for storage and performance optimizations?

Re: largest table last in joins

Hi, If we have one big table joining with a small table and MAPJOIN hint is specified on the Smaller table, still the ordering will be required? We can always forcefully set the auto convert join property to false and enable mapjoin hints. Please let me know if I am off base on this topic.