Hello. Please see attached DS2 program.   My understanding is as follows: In the method SumPlus , V1  receives a datatype of double. However, when called/instantiated, TotalA is converted ( or coerced ? )from char to double. This enables addition in the method without a compile error, ( Is my thinking correct so far ? )   Going through the do ..end loop, we should, in my mind, have the following values as we go through the 3 iterations:   Iteration1 TotalB = 1   TotalA =  101  GrandTot = 102 ( 101 + 1 ) Iteration2 TotalB = 2   TotalA =  101  GrandTot = 103 ( 102 + 1 ) Iteration1 TotalB = 3   TotalA =  101  GrandTot = 104 ( 103 + 1 )   The answer says TotalB = 4 ! Please help.   Thanks. Odesh.         ... View more

Hello, In the context of PROC IMSTAT , I am trying to understand the meaning of "SCHEMA".   SCHEMA  stores the results in a temporary table that can be accessed by using &_TEMPLAST_. SCHEMA can also be used to join a fact table to one or more dimension tables.   Questions: 1. Are both of the above statements correct ? 2. Is there any relationship between the two statements or is the use of the word "SCHEMA"  purely coincidental ?   No attachments.   Thanks. Odesh.           ... View more

Hello, I do not quite understand why we  need the concept of tags with PROC LASR. In the example given, could be not simply name the 2 tables to be unique:   1. mylaser.bank_prd  2. mylaser.bank_dev      or something similar rather than having to define a new concept of  "tags".  I must be missing something ..   Regards. Odesh   ... View more

Hello, I need a quick clarification of syntax. Please see bottom line of attachment.   I am not sure what the asterisks mean in *00/part* ?   Thanks. Odesh.   ... View more

Hello, My question is about PROC FedSQL.  I have used PROC SQL before but not FedSQL prior to this course. 1.  Why is PROC FedSQL used exclusively in this course and not PROC SQL ? 2. My understanding is that PROC FedSQL is more general and far-reaching than PROC SQL and can somehow access data form many other platforms and databases than PROC SQL .  Is this true and if so, how is this accomplished ?   Thanks. Odesh. ... View more

I am looking for a general but comprehensive list of differences between HIve and PIG. So far, my limited understanding is  as follows:   1. HIve ( and HIVE QL ) are  similar to RDBMSs like Oracle, Teradata, SQL SErver etc. ( datatypes , database operations , table operations etc.)   2. I am not sure whether the concept of schema in Hive ( or HiveQL ) is different from that of the usual RDMS . Is it  and if so, how ? Is there a schema concept in PIG and the related PIG language ?   3. HiveQL in my mind sits on top of MapReduce and all HiveQL queries and compiled and optimized into one or more Map Reduce programs before these are run on thr HADOOP cluster.   4. What happens in a Mapping as opposed to a Reduce.  What operations would be translated into a Mapping or Reduce or both ?   5 Why was Java chosen as the language for writing the code that would finally be run on the HADOOP cluster ?   6. PIG is even more high level than HiveQL and is useful for applications that can be structured as a data-flow format. What would be real-life examples of applications that be suitable for PIG ( and Grunt) as oposed to HiveQL and Beeline ?  What would be examples where PIG would not be a good choice ?   Please tell me  where I understand things correctly and where I do not.   Thanks. Odesh.   ... View more

Hello, I am getting  error ( WARN) messages when I type pig at the LInux command line. PLease see attachment.  This happens at Step 1(b).   I thought that because these are WARNings the LOAD command at Step 1(d) might still work. Unfortunately, the LOAD commnad did not work at step 3.   Please help - without loading the data I cannot do any of the PIG exercises or follow the demos on my machine.   Thanks. Odesh. ... View more