Home Forums Pig Sandbox 1.2: There is an error

This topic contains 1 reply, has 2 voices, and was last updated by  tedr 1 year, 2 months ago.

  • Creator
    Topic
  • #27505

    Hi All,

    I’m evaluating Hadoop technology and your sandbox. I’m new about Hadoop, so I’m studing and doing my homework with your tutorials.
    So, I’m here to ask you a little help for my pig’s problem.

    This script doesn’t work:
    a = load ‘nyse_stock’ using org.apache.hcatalog.pig.HCatLoader();
    b = filter a by stock_symbol == ‘ASP’;
    c = group b all;
    d = foreach c generate AVG(b.stock_volume);
    dump d;

    Here the logs:

    2013-06-14 05:06:30,292 [main] INFO org.apache.pig.Main – Apache Pig version 0.10.1.21 (rexported) compiled Jan 10 2013, 04:00:42
    2013-06-14 05:06:30,293 [main] INFO org.apache.pig.Main – Logging error messages to: /home/sandbox/hue/pig_1371211590290.log
    2013-06-14 05:06:30,706 [main] INFO org.apache.pig.backend.hadoop.executionengine.HExecutionEngine – Connecting to hadoop file system at: file:///
    2013-06-14 05:06:31,927 [main] WARN org.apache.hadoop.hive.conf.HiveConf – DEPRECATED: Configuration property hive.metastore.local no longer has any effect. Make sure to provide a valid value for hive.metastore.uris if you are connecting to a remote metastore.
    2013-06-14 05:06:32,064 [main] INFO hive.metastore – Trying to connect to metastore with URI thrift://sandbox:9083
    2013-06-14 05:06:32,129 [main] INFO hive.metastore – Waiting 1 seconds before next connection attempt.
    2013-06-14 05:06:33,129 [main] INFO hive.metastore – Connected to metastore.
    2013-06-14 05:06:33,404 [main] WARN org.apache.hadoop.hive.conf.HiveConf – DEPRECATED: Configuration property hive.metastore.local no longer has any effect. Make sure to provide a valid value for hive.metastore.uris if you are connecting to a remote metastore.
    2013-06-14 05:06:33,552 [main] WARN org.apache.hadoop.hive.conf.HiveConf – DEPRECATED: Configuration property hive.metastore.local no longer has any effect. Make sure to provide a valid value for hive.metastore.uris if you are connecting to a remote metastore.
    2013-06-14 05:06:33,651 [main] WARN org.apache.hadoop.hive.conf.HiveConf – DEPRECATED: Configuration property hive.metastore.local no longer has any effect. Make sure to provide a valid value for hive.metastore.uris if you are connecting to a remote metastore.
    2013-06-14 05:06:33,742 [main] WARN org.apache.hadoop.hive.conf.HiveConf – DEPRECATED: Configuration property hive.metastore.local no longer has any effect. Make sure to provide a valid value for hive.metastore.uris if you are connecting to a remote metastore.
    2013-06-14 05:06:33,881 [main] WARN org.apache.hadoop.hive.conf.HiveConf – DEPRECATED: Configuration property hive.metastore.local no longer has any effect. Make sure to provide a valid value for hive.metastore.uris if you are connecting to a remote metastore.
    2013-06-14 05:06:33,943 [main] ERROR org.apache.pig.tools.grunt.Grunt – ERROR 1045:
    Could not infer the matching function for org.apache.pig.builtin.AVG as multiple or none of them fit. Please use an explicit cast.
    Details at logfile: /home/sandbox/hue/pig_1371211590290.log

    Can you help me?

    Regards.

Viewing 1 replies (of 1 total)

You must be logged in to reply to this topic.

  • Author
    Replies
  • #27745

    tedr
    Moderator

    Hi Francesco,

    That script runs perfectly in my copy of Sandbox 1.2. The only bit I ran into when I copied and pasted it that the forum software inserted the magic single quote characters rather than just the single quote character.

    Thanks,
    Ted.

    Collapse
Viewing 1 replies (of 1 total)