Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 03EE5200D33 for ; Wed, 8 Nov 2017 08:58:25 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id 02502160BE0; Wed, 8 Nov 2017 07:58:25 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 47308160BDA for ; Wed, 8 Nov 2017 08:58:24 +0100 (CET) Received: (qmail 75987 invoked by uid 500); 8 Nov 2017 07:58:23 -0000 Mailing-List: contact dev-help@impala.incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@impala.incubator.apache.org Delivered-To: mailing list dev@impala.incubator.apache.org Received: (qmail 75975 invoked by uid 99); 8 Nov 2017 07:58:22 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd1-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 08 Nov 2017 07:58:22 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd1-us-west.apache.org (ASF Mail Server at spamd1-us-west.apache.org) with ESMTP id E7E8DED3E9 for ; Wed, 8 Nov 2017 07:58:21 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.379 X-Spam-Level: ** X-Spam-Status: No, score=2.379 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, RCVD_IN_SORBS_SPAM=0.5, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd1-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd1-us-west.apache.org [10.40.0.7]) (amavisd-new, port 10024) with ESMTP id kqYh3c74kynT for ; Wed, 8 Nov 2017 07:58:20 +0000 (UTC) Received: from mail-ot0-f173.google.com (mail-ot0-f173.google.com [74.125.82.173]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTPS id F39CB694F5 for ; Wed, 8 Nov 2017 07:03:20 +0000 (UTC) Received: by mail-ot0-f173.google.com with SMTP id k10so1517116otb.0 for ; Tue, 07 Nov 2017 23:03:20 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:from:date:message-id:subject:to; bh=lIJoIi3zA0nETEwkVDzFVTIxetO2z8S5gA+y6sF68pE=; b=TQcPtezMpCTt2db9wt0YZGY3GY2e+AiQvNLQI3MiShbNvqK60Z2HWOKchoR8J2K/VK kOuAO22ZZOItFLybDAFDJrhxskQ7c/JRYBu9l3eJ71a92LQnVytum3G/K7ezBufwNR/T UYixW94/5vEzED9aNf0/epZ67eVrkTKyVqAOS/kj4npIAhhQGPMpnaZIpie2kE0vWpXo NAdeNgpm/cbi68/8UggcAOgytSxTWo7D1Bg8Sgu2MSl/l6UjM0mvdYBUeXIoi8HfpmSi bcVurMI/zRYjXhqt0mi9zEKusUcZuiKa3T97CW9QePZislOpg6as0qidSpVqr3GU5+OS /jQA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=lIJoIi3zA0nETEwkVDzFVTIxetO2z8S5gA+y6sF68pE=; b=dCpXnnFYLTgBwmCcoHOwQITTBO3gXCLT/TDQ/Slx6sY0S84NVbH5wReif5PFYb56qo yflL/MqJizdhslR7xmTtRYnstQLDgg5odmwu8HJk+TA+/z+IHzW06VOeRRmxpqvqWGXF UI2SewrgSnJPxlK9LUCdffiT7z+pUIlUhfrpMJpgKtnsz1h6Mo6alt0wKoxAX25XEuX1 pNmnnc6cS79LiWVdmpgaNkzlKNen7EN0IB7owCM7oMD2FfpqL5vGq0w+jSiQ8L3FwiNj X8e+hOh35SoU7GMPxHLNBXYw6kCJUtlwQrfgNalNviegb2vhyhJyvd4fThmfNvi0q25j v9EQ== X-Gm-Message-State: AJaThX5SWZ1kKqNbAlM/TGMIINXH8xab6FlX/ayBRAmbDX4dIzQiyaEz F8JYODke9tGMea1Xz7fVVJJvEG84WYYHgNfKc6ODfA== X-Google-Smtp-Source: AGs4zMZs68De7eNDelpCmtjJUDZOCJKpHDGZQQIF2nnuQvJPyJlD/GG8eEZ+CkhT1VDIfKrUSopwcH5zJu5wAvWmvas= X-Received: by 10.157.66.140 with SMTP id r12mr801165ote.359.1510124593830; Tue, 07 Nov 2017 23:03:13 -0800 (PST) MIME-Version: 1.0 Received: by 10.74.197.66 with HTTP; Tue, 7 Nov 2017 23:03:13 -0800 (PST) From: Jin Chul Kim Date: Wed, 8 Nov 2017 16:03:13 +0900 Message-ID: Subject: A question about loading data by functional-query workload To: dev@impala.incubator.apache.org Content-Type: multipart/alternative; boundary="94eb2c1bff7efb6048055d73473a" archived-at: Wed, 08 Nov 2017 07:58:25 -0000 --94eb2c1bff7efb6048055d73473a Content-Type: text/plain; charset="UTF-8" Hi, I would like to run E2E test using the document: https://cwiki.apache.org/ confluence/display/IMPALA/How+to+load+and+run+Impala+tests. Here is my command: ./tests/run-tests.py query_test/test_queries.py -k TestQueriesTextTables It failed with not found functional database. Should I load data manually? Anyway, I found ./bin/load-data.sh by chance and I ran it with the command: ./bin/load-data.py -w functional-query By the way, it failed with not found matching path file: ${IMPALA_HOME}/testdata/target/AllTypes/090101.txt. I don't find the directory ${IMPALA_HOME}/testdata/target/AllTypes. I guess it can be generated internally. Would you please guide me? 0: jdbc:hive2://localhost:11050/default> LOAD DATA LOCAL INPATH '/home/jinchulkim/workspace/Impala/testdata/target/AllTypes/090101.txt' OVERWRITE INTO TABLE functional.alltypes PARTITION(year=2009, month=1); going to print operations logs printed operations logs Getting log thread is interrupted, since query is done! Error: Error while compiling statement: FAILED: SemanticException Line 1:23 Invalid path ''/home/jinchulkim/workspace/Impala/testdata/target/AllTypes/090101.txt'': No files matching path file:/home/jinchulkim/workspace/Impala/testdata/target/AllTypes/090101.txt (state=42000,code=40000) org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: SemanticException Line 1:23 Invalid path ''/home/jinchulkim/workspace/Impala/testdata/target/AllTypes/090101.txt'': No files matching path file:/home/jinchulkim/workspace/Impala/testdata/ target/AllTypes/090101.txt Best regards, Jinchul --94eb2c1bff7efb6048055d73473a--