{ "cells": [ { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [], "source": [ "import datetime,time\n", "from multiprocessing import Pool\n", "import json\n", "import os\n", "import traceback\n", "import warnings\n", "import numpy as np\n", "\n", "from sqlalchemy import text, delete, and_, or_, update\n", "import pandas as pd\n", "\n", "from ZlwlAlgosCommon.utils.ProUtils import *\n", "from ZlwlAlgosCommon.service.iotp.IotpAlgoService import IotpAlgoService\n", "from ZlwlAlgosCommon.service.iotp.Beans import DataField\n", "from ZlwlAlgosCommon.orm.models import *" ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [], "source": [ "##绘图需要的包\n", "import math\n", "import folium" ] }, { "cell_type": "code", "execution_count": 3, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "start env: dev \n" ] } ], "source": [ "cur_env = 'dev' # 设置运行环境\n", "app_path = \"/home/likun/project/zlwl-algos/\" # 设置app绝对路径\n", "sysUtils = SysUtils(cur_env, app_path)\n", "mysql_algo_params = sysUtils.get_cf_param('mysql-algo')\n", "mysqlUtils = MysqlUtils()\n", "mysql_algo_engine, mysql_algo_Session= mysqlUtils.get_mysql_engine(mysql_algo_params)\n", "mysql_algo_conn = mysql_algo_engine.connect()\n", "hbase_params = sysUtils.get_cf_param('hbase-datafactory')\n", "iotp_service = IotpAlgoService(hbase_params=hbase_params)" ] }, { "cell_type": "code", "execution_count": 29, "metadata": {}, "outputs": [], "source": [ "df_snpk_list = pd.read_sql(\"select sn, imei,pack_model,device_cell_type from t_device\", mysql_algo_conn)\n", "df_snpk_list=df_snpk_list[df_snpk_list['sn'].str.contains('LY9')].copy()\n", "df_snpk_list=df_snpk_list.reset_index(drop=True)" ] }, { "cell_type": "code", "execution_count": 30, "metadata": {}, "outputs": [], "source": [ "rng1 = pd.date_range('2022-01-01 00:00:00','2022-12-01 00:00:00' , freq = 'M')\n", "rng2 = pd.date_range('2022-02-01 00:00:00','2023-01-01 00:00:00' , freq = 'M')\n", "st=[i.strftime('%Y-%m-%d %H:%M:%S') for i in rng1]\n", "et=[i.strftime('%Y-%m-%d %H:%M:%S') for i in rng2]" ] }, { "cell_type": "code", "execution_count": 31, "metadata": {}, "outputs": [], "source": [ "gps_last_t= pd.DataFrame()" ] }, { "cell_type": "code", "execution_count": 32, "metadata": {}, "outputs": [], "source": [ "##经纬度转化函数" ] }, { "cell_type": "code", "execution_count": 4, "metadata": {}, "outputs": [], "source": [ "import math\n", "\n", "pi = 3.1415926535897932384626\n", "a = 6378245.0\n", "ee = 0.00669342162296594323\n", "\n", "\n", "def wgs_gcj(lat, lon):\n", "\n", " dLat = transform_lat(lon - 105.0, lat - 35.0)\n", " dLon = transform_lon(lon - 105.0, lat - 35.0)\n", " radLat = lat / 180.0 * pi\n", " magic = math.sin(radLat)\n", " magic = 1 - ee * magic * magic\n", " sqrtMagic = math.sqrt(magic)\n", " dLat = (dLat * 180.0) / ((a * (1 - ee)) / (magic * sqrtMagic) * pi)\n", " dLon = (dLon * 180.0) / (a / sqrtMagic * math.cos(radLat) * pi)\n", " mgLat = lat + dLat\n", " mgLon = lon + dLon\n", " return [mgLat,mgLon]\n", "\n", "\n", "def transform_lat(x, y):\n", "\n", " ret = -100.0 + 2.0 * x + 3.0 * y + 0.2 * y * y + 0.1 * x * y + 0.2 * math.sqrt(abs(x))\n", " ret += (20.0 * math.sin(6.0 * x * pi) + 20.0 * math.sin(2.0 * x * pi)) * 2.0 / 3.0\n", " ret += (20.0 * math.sin(y * pi) + 40.0 * math.sin(y / 3.0 * pi)) * 2.0 / 3.0\n", " ret += (160.0 * math.sin(y / 12.0 * pi) + 320 * math.sin(y * pi / 30.0)) * 2.0 / 3.0\n", " return ret\n", "\n", "\n", "def transform_lon(x, y):\n", "\n", " ret = 300.0 + x + 2.0 * y + 0.1 * x * x + 0.1 * x * y + 0.1 * math.sqrt(abs(x))\n", " ret += (20.0 * math.sin(6.0 * x * pi) + 20.0 * math.sin(2.0 * x * pi)) * 2.0 / 3.0\n", " ret += (20.0 * math.sin(x * pi) + 40.0 * math.sin(x / 3.0 * pi)) * 2.0 / 3.0\n", " ret += (150.0 * math.sin(x / 12.0 * pi) + 300.0 * math.sin(x / 30.0 * pi)) * 2.0 / 3.0\n", " return ret" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "##按车绘制" ] }, { "cell_type": "code", "execution_count": 34, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "LY9139BB0MALBZ308-2022-01-31 00:00:00-2022-02-28 00:00:00开始取数.........\n", "连接hbase数据库\n", "连接hbase数据库 成功\n", "Spend_time:0.000926971435546875 s\n", "LY9139BB0MALBZ308-2022-01-31 00:00:00-2022-02-28 00:00:00取数完成.........\n", "\"None of [Index(['time', 'sn', 'latitude', 'longitude'], dtype='object')] are in the [columns]\"\n", "LY9139BB0MALBZ308-2022-02-28 00:00:00-2022-03-31 00:00:00开始取数.........\n", "Spend_time:0.0003445148468017578 s\n", "LY9139BB0MALBZ308-2022-02-28 00:00:00-2022-03-31 00:00:00取数完成.........\n", "\"None of [Index(['time', 'sn', 'latitude', 'longitude'], dtype='object')] are in the [columns]\"\n", "LY9139BB0MALBZ308-2022-03-31 00:00:00-2022-04-30 00:00:00开始取数.........\n", "Spend_time:0.0004296302795410156 s\n", "LY9139BB0MALBZ308-2022-03-31 00:00:00-2022-04-30 00:00:00取数完成.........\n", "\"None of [Index(['time', 'sn', 'latitude', 'longitude'], dtype='object')] are in the [columns]\"\n", "LY9139BB0MALBZ308-2022-04-30 00:00:00-2022-05-31 00:00:00开始取数.........\n", "Spend_time:0.06450557708740234 s\n", "LY9139BB0MALBZ308-2022-04-30 00:00:00-2022-05-31 00:00:00取数完成.........\n", "LY9139BB0MALBZ308-2022-05-31 00:00:00-2022-06-30 00:00:00开始取数.........\n", "Spend_time:0.22917747497558594 s\n", "LY9139BB0MALBZ308-2022-05-31 00:00:00-2022-06-30 00:00:00取数完成.........\n", "LY9139BB0MALBZ308-2022-06-30 00:00:00-2022-07-31 00:00:00开始取数.........\n", "Spend_time:5.000519514083862 s\n", "LY9139BB0MALBZ308-2022-06-30 00:00:00-2022-07-31 00:00:00取数完成.........\n", "LY9139BB0MALBZ308-2022-07-31 00:00:00-2022-08-31 00:00:00开始取数.........\n", "Spend_time:3.8071608543395996 s\n", "LY9139BB0MALBZ308-2022-07-31 00:00:00-2022-08-31 00:00:00取数完成.........\n", "LY9139BB0MALBZ308-2022-08-31 00:00:00-2022-09-30 00:00:00开始取数.........\n", "Spend_time:6.258041620254517 s\n", "LY9139BB0MALBZ308-2022-08-31 00:00:00-2022-09-30 00:00:00取数完成.........\n", "LY9139BB0MALBZ308-2022-09-30 00:00:00-2022-10-31 00:00:00开始取数.........\n", "Spend_time:3.9882314205169678 s\n", "LY9139BB0MALBZ308-2022-09-30 00:00:00-2022-10-31 00:00:00取数完成.........\n", "LY9139BB0MALBZ308-2022-10-31 00:00:00-2022-11-30 00:00:00开始取数.........\n", "Spend_time:2.77192759513855 s\n", "LY9139BB0MALBZ308-2022-10-31 00:00:00-2022-11-30 00:00:00取数完成.........\n", "LY9139BB0MALBZ308-2022-11-30 00:00:00-2022-12-31 00:00:00开始取数.........\n", "Spend_time:0.0005524158477783203 s\n", "LY9139BB0MALBZ308-2022-11-30 00:00:00-2022-12-31 00:00:00取数完成.........\n", "\"None of [Index(['time', 'sn', 'latitude', 'longitude'], dtype='object')] are in the [columns]\"\n", "LY9139BB0MALBZ325-2022-01-31 00:00:00-2022-02-28 00:00:00开始取数.........\n", "Spend_time:1.64402174949646 s\n", "LY9139BB0MALBZ325-2022-01-31 00:00:00-2022-02-28 00:00:00取数完成.........\n", "LY9139BB0MALBZ325-2022-02-28 00:00:00-2022-03-31 00:00:00开始取数.........\n", "Spend_time:1.9150621891021729 s\n", "LY9139BB0MALBZ325-2022-02-28 00:00:00-2022-03-31 00:00:00取数完成.........\n", "LY9139BB0MALBZ325-2022-03-31 00:00:00-2022-04-30 00:00:00开始取数.........\n", "Spend_time:0.6118218898773193 s\n", "LY9139BB0MALBZ325-2022-03-31 00:00:00-2022-04-30 00:00:00取数完成.........\n", "LY9139BB0MALBZ325-2022-04-30 00:00:00-2022-05-31 00:00:00开始取数.........\n", "Spend_time:2.7551426887512207 s\n", "LY9139BB0MALBZ325-2022-04-30 00:00:00-2022-05-31 00:00:00取数完成.........\n", "LY9139BB0MALBZ325-2022-05-31 00:00:00-2022-06-30 00:00:00开始取数.........\n", "Spend_time:3.6855461597442627 s\n", "LY9139BB0MALBZ325-2022-05-31 00:00:00-2022-06-30 00:00:00取数完成.........\n", "LY9139BB0MALBZ325-2022-06-30 00:00:00-2022-07-31 00:00:00开始取数.........\n", "Spend_time:3.9091928005218506 s\n", "LY9139BB0MALBZ325-2022-06-30 00:00:00-2022-07-31 00:00:00取数完成.........\n", "LY9139BB0MALBZ325-2022-07-31 00:00:00-2022-08-31 00:00:00开始取数.........\n", "Spend_time:3.4472601413726807 s\n", "LY9139BB0MALBZ325-2022-07-31 00:00:00-2022-08-31 00:00:00取数完成.........\n", "LY9139BB0MALBZ325-2022-08-31 00:00:00-2022-09-30 00:00:00开始取数.........\n", "Spend_time:3.685687303543091 s\n", "LY9139BB0MALBZ325-2022-08-31 00:00:00-2022-09-30 00:00:00取数完成.........\n", "LY9139BB0MALBZ325-2022-09-30 00:00:00-2022-10-31 00:00:00开始取数.........\n", "Spend_time:3.1152541637420654 s\n", "LY9139BB0MALBZ325-2022-09-30 00:00:00-2022-10-31 00:00:00取数完成.........\n", "LY9139BB0MALBZ325-2022-10-31 00:00:00-2022-11-30 00:00:00开始取数.........\n", "Spend_time:5.268474817276001 s\n", "LY9139BB0MALBZ325-2022-10-31 00:00:00-2022-11-30 00:00:00取数完成.........\n", "LY9139BB0MALBZ325-2022-11-30 00:00:00-2022-12-31 00:00:00开始取数.........\n", "Spend_time:0.3653829097747803 s\n", "LY9139BB0MALBZ325-2022-11-30 00:00:00-2022-12-31 00:00:00取数完成.........\n", "LY9139BB0MALBZ423-2022-01-31 00:00:00-2022-02-28 00:00:00开始取数.........\n", "Spend_time:2.2429661750793457 s\n", "LY9139BB0MALBZ423-2022-01-31 00:00:00-2022-02-28 00:00:00取数完成.........\n", "LY9139BB0MALBZ423-2022-02-28 00:00:00-2022-03-31 00:00:00开始取数.........\n", "Spend_time:5.180966377258301 s\n", "LY9139BB0MALBZ423-2022-02-28 00:00:00-2022-03-31 00:00:00取数完成.........\n", "LY9139BB0MALBZ423-2022-03-31 00:00:00-2022-04-30 00:00:00开始取数.........\n", "Spend_time:5.381983041763306 s\n", "LY9139BB0MALBZ423-2022-03-31 00:00:00-2022-04-30 00:00:00取数完成.........\n", "LY9139BB0MALBZ423-2022-04-30 00:00:00-2022-05-31 00:00:00开始取数.........\n", "Spend_time:3.9608898162841797 s\n", "LY9139BB0MALBZ423-2022-04-30 00:00:00-2022-05-31 00:00:00取数完成.........\n", "LY9139BB0MALBZ423-2022-05-31 00:00:00-2022-06-30 00:00:00开始取数.........\n", "Spend_time:3.965160608291626 s\n", "LY9139BB0MALBZ423-2022-05-31 00:00:00-2022-06-30 00:00:00取数完成.........\n", "LY9139BB0MALBZ423-2022-06-30 00:00:00-2022-07-31 00:00:00开始取数.........\n", "Spend_time:3.9950289726257324 s\n", "LY9139BB0MALBZ423-2022-06-30 00:00:00-2022-07-31 00:00:00取数完成.........\n", "LY9139BB0MALBZ423-2022-07-31 00:00:00-2022-08-31 00:00:00开始取数.........\n", "Spend_time:3.0249369144439697 s\n", "LY9139BB0MALBZ423-2022-07-31 00:00:00-2022-08-31 00:00:00取数完成.........\n", "LY9139BB0MALBZ423-2022-08-31 00:00:00-2022-09-30 00:00:00开始取数.........\n", "Spend_time:3.265047788619995 s\n", "LY9139BB0MALBZ423-2022-08-31 00:00:00-2022-09-30 00:00:00取数完成.........\n", "LY9139BB0MALBZ423-2022-09-30 00:00:00-2022-10-31 00:00:00开始取数.........\n", "Spend_time:4.57024884223938 s\n", "LY9139BB0MALBZ423-2022-09-30 00:00:00-2022-10-31 00:00:00取数完成.........\n", "LY9139BB0MALBZ423-2022-10-31 00:00:00-2022-11-30 00:00:00开始取数.........\n", "Spend_time:5.046443462371826 s\n", "LY9139BB0MALBZ423-2022-10-31 00:00:00-2022-11-30 00:00:00取数完成.........\n", "LY9139BB0MALBZ423-2022-11-30 00:00:00-2022-12-31 00:00:00开始取数.........\n", "Spend_time:0.3097865581512451 s\n", "LY9139BB0MALBZ423-2022-11-30 00:00:00-2022-12-31 00:00:00取数完成.........\n", "LY9139BB0MALBZ504-2022-01-31 00:00:00-2022-02-28 00:00:00开始取数.........\n", "Spend_time:3.0393338203430176 s\n", "LY9139BB0MALBZ504-2022-01-31 00:00:00-2022-02-28 00:00:00取数完成.........\n", "LY9139BB0MALBZ504-2022-02-28 00:00:00-2022-03-31 00:00:00开始取数.........\n", "Spend_time:5.647546052932739 s\n", "LY9139BB0MALBZ504-2022-02-28 00:00:00-2022-03-31 00:00:00取数完成.........\n", "LY9139BB0MALBZ504-2022-03-31 00:00:00-2022-04-30 00:00:00开始取数.........\n", "Spend_time:3.746067762374878 s\n", "LY9139BB0MALBZ504-2022-03-31 00:00:00-2022-04-30 00:00:00取数完成.........\n", "LY9139BB0MALBZ504-2022-04-30 00:00:00-2022-05-31 00:00:00开始取数.........\n", "Spend_time:7.983382701873779 s\n", "LY9139BB0MALBZ504-2022-04-30 00:00:00-2022-05-31 00:00:00取数完成.........\n", "LY9139BB0MALBZ504-2022-05-31 00:00:00-2022-06-30 00:00:00开始取数.........\n", "Spend_time:4.72435188293457 s\n", "LY9139BB0MALBZ504-2022-05-31 00:00:00-2022-06-30 00:00:00取数完成.........\n", "LY9139BB0MALBZ504-2022-06-30 00:00:00-2022-07-31 00:00:00开始取数.........\n", "Spend_time:4.157829761505127 s\n", "LY9139BB0MALBZ504-2022-06-30 00:00:00-2022-07-31 00:00:00取数完成.........\n", "LY9139BB0MALBZ504-2022-07-31 00:00:00-2022-08-31 00:00:00开始取数.........\n", "Spend_time:5.830103874206543 s\n", "LY9139BB0MALBZ504-2022-07-31 00:00:00-2022-08-31 00:00:00取数完成.........\n", "LY9139BB0MALBZ504-2022-08-31 00:00:00-2022-09-30 00:00:00开始取数.........\n", "Spend_time:3.651881694793701 s\n", "LY9139BB0MALBZ504-2022-08-31 00:00:00-2022-09-30 00:00:00取数完成.........\n", "LY9139BB0MALBZ504-2022-09-30 00:00:00-2022-10-31 00:00:00开始取数.........\n", "Spend_time:3.1627299785614014 s\n", "LY9139BB0MALBZ504-2022-09-30 00:00:00-2022-10-31 00:00:00取数完成.........\n", "LY9139BB0MALBZ504-2022-10-31 00:00:00-2022-11-30 00:00:00开始取数.........\n", "Spend_time:6.832413673400879 s\n", "LY9139BB0MALBZ504-2022-10-31 00:00:00-2022-11-30 00:00:00取数完成.........\n", "LY9139BB0MALBZ504-2022-11-30 00:00:00-2022-12-31 00:00:00开始取数.........\n", "Spend_time:0.2319486141204834 s\n", "LY9139BB0MALBZ504-2022-11-30 00:00:00-2022-12-31 00:00:00取数完成.........\n", "LY9139BB0MALBZ793-2022-01-31 00:00:00-2022-02-28 00:00:00开始取数.........\n", "Spend_time:7.227718114852905 s\n", "LY9139BB0MALBZ793-2022-01-31 00:00:00-2022-02-28 00:00:00取数完成.........\n", "LY9139BB0MALBZ793-2022-02-28 00:00:00-2022-03-31 00:00:00开始取数.........\n", "Spend_time:4.9399895668029785 s\n", "LY9139BB0MALBZ793-2022-02-28 00:00:00-2022-03-31 00:00:00取数完成.........\n", "LY9139BB0MALBZ793-2022-03-31 00:00:00-2022-04-30 00:00:00开始取数.........\n", "Spend_time:4.708398818969727 s\n", "LY9139BB0MALBZ793-2022-03-31 00:00:00-2022-04-30 00:00:00取数完成.........\n", "LY9139BB0MALBZ793-2022-04-30 00:00:00-2022-05-31 00:00:00开始取数.........\n", "Spend_time:4.5900726318359375 s\n", "LY9139BB0MALBZ793-2022-04-30 00:00:00-2022-05-31 00:00:00取数完成.........\n", "LY9139BB0MALBZ793-2022-05-31 00:00:00-2022-06-30 00:00:00开始取数.........\n", "Spend_time:5.132660150527954 s\n", "LY9139BB0MALBZ793-2022-05-31 00:00:00-2022-06-30 00:00:00取数完成.........\n", "LY9139BB0MALBZ793-2022-06-30 00:00:00-2022-07-31 00:00:00开始取数.........\n", "Spend_time:4.687474250793457 s\n", "LY9139BB0MALBZ793-2022-06-30 00:00:00-2022-07-31 00:00:00取数完成.........\n", "LY9139BB0MALBZ793-2022-07-31 00:00:00-2022-08-31 00:00:00开始取数.........\n", "Spend_time:4.0204081535339355 s\n", "LY9139BB0MALBZ793-2022-07-31 00:00:00-2022-08-31 00:00:00取数完成.........\n", "LY9139BB0MALBZ793-2022-08-31 00:00:00-2022-09-30 00:00:00开始取数.........\n", "Spend_time:3.512667655944824 s\n", "LY9139BB0MALBZ793-2022-08-31 00:00:00-2022-09-30 00:00:00取数完成.........\n", "LY9139BB0MALBZ793-2022-09-30 00:00:00-2022-10-31 00:00:00开始取数.........\n", "Spend_time:3.9676668643951416 s\n", "LY9139BB0MALBZ793-2022-09-30 00:00:00-2022-10-31 00:00:00取数完成.........\n", "LY9139BB0MALBZ793-2022-10-31 00:00:00-2022-11-30 00:00:00开始取数.........\n", "Spend_time:6.123051166534424 s\n", "LY9139BB0MALBZ793-2022-10-31 00:00:00-2022-11-30 00:00:00取数完成.........\n", "LY9139BB0MALBZ793-2022-11-30 00:00:00-2022-12-31 00:00:00开始取数.........\n", "Spend_time:0.13434743881225586 s\n", "LY9139BB0MALBZ793-2022-11-30 00:00:00-2022-12-31 00:00:00取数完成.........\n", "LY9139BB0MALBZ809-2022-01-31 00:00:00-2022-02-28 00:00:00开始取数.........\n", "Spend_time:3.6040568351745605 s\n", "LY9139BB0MALBZ809-2022-01-31 00:00:00-2022-02-28 00:00:00取数完成.........\n", "LY9139BB0MALBZ809-2022-02-28 00:00:00-2022-03-31 00:00:00开始取数.........\n", "Spend_time:3.362354278564453 s\n", "LY9139BB0MALBZ809-2022-02-28 00:00:00-2022-03-31 00:00:00取数完成.........\n", "LY9139BB0MALBZ809-2022-03-31 00:00:00-2022-04-30 00:00:00开始取数.........\n", "Spend_time:4.605651617050171 s\n", "LY9139BB0MALBZ809-2022-03-31 00:00:00-2022-04-30 00:00:00取数完成.........\n", "LY9139BB0MALBZ809-2022-04-30 00:00:00-2022-05-31 00:00:00开始取数.........\n", "Spend_time:4.808942794799805 s\n", "LY9139BB0MALBZ809-2022-04-30 00:00:00-2022-05-31 00:00:00取数完成.........\n", "LY9139BB0MALBZ809-2022-05-31 00:00:00-2022-06-30 00:00:00开始取数.........\n", "Spend_time:2.723421573638916 s\n", "LY9139BB0MALBZ809-2022-05-31 00:00:00-2022-06-30 00:00:00取数完成.........\n", "LY9139BB0MALBZ809-2022-06-30 00:00:00-2022-07-31 00:00:00开始取数.........\n", "Spend_time:2.737412214279175 s\n", "LY9139BB0MALBZ809-2022-06-30 00:00:00-2022-07-31 00:00:00取数完成.........\n", "LY9139BB0MALBZ809-2022-07-31 00:00:00-2022-08-31 00:00:00开始取数.........\n", "Spend_time:4.872450590133667 s\n", "LY9139BB0MALBZ809-2022-07-31 00:00:00-2022-08-31 00:00:00取数完成.........\n", "LY9139BB0MALBZ809-2022-08-31 00:00:00-2022-09-30 00:00:00开始取数.........\n", "Spend_time:3.9603378772735596 s\n", "LY9139BB0MALBZ809-2022-08-31 00:00:00-2022-09-30 00:00:00取数完成.........\n", "LY9139BB0MALBZ809-2022-09-30 00:00:00-2022-10-31 00:00:00开始取数.........\n", "Spend_time:4.898382186889648 s\n", "LY9139BB0MALBZ809-2022-09-30 00:00:00-2022-10-31 00:00:00取数完成.........\n", "LY9139BB0MALBZ809-2022-10-31 00:00:00-2022-11-30 00:00:00开始取数.........\n", "Spend_time:5.089494943618774 s\n", "LY9139BB0MALBZ809-2022-10-31 00:00:00-2022-11-30 00:00:00取数完成.........\n", "LY9139BB0MALBZ809-2022-11-30 00:00:00-2022-12-31 00:00:00开始取数.........\n", "Spend_time:0.4749453067779541 s\n", "LY9139BB0MALBZ809-2022-11-30 00:00:00-2022-12-31 00:00:00取数完成.........\n", "LY9139BB0MALBZ812-2022-01-31 00:00:00-2022-02-28 00:00:00开始取数.........\n", "Spend_time:3.429107666015625 s\n", "LY9139BB0MALBZ812-2022-01-31 00:00:00-2022-02-28 00:00:00取数完成.........\n", "LY9139BB0MALBZ812-2022-02-28 00:00:00-2022-03-31 00:00:00开始取数.........\n", "Spend_time:2.845797300338745 s\n", "LY9139BB0MALBZ812-2022-02-28 00:00:00-2022-03-31 00:00:00取数完成.........\n", "LY9139BB0MALBZ812-2022-03-31 00:00:00-2022-04-30 00:00:00开始取数.........\n", "Spend_time:3.8377604484558105 s\n", "LY9139BB0MALBZ812-2022-03-31 00:00:00-2022-04-30 00:00:00取数完成.........\n", "LY9139BB0MALBZ812-2022-04-30 00:00:00-2022-05-31 00:00:00开始取数.........\n", "Spend_time:1.684171199798584 s\n", "LY9139BB0MALBZ812-2022-04-30 00:00:00-2022-05-31 00:00:00取数完成.........\n", "LY9139BB0MALBZ812-2022-05-31 00:00:00-2022-06-30 00:00:00开始取数.........\n", "Spend_time:3.8846967220306396 s\n", "LY9139BB0MALBZ812-2022-05-31 00:00:00-2022-06-30 00:00:00取数完成.........\n", "LY9139BB0MALBZ812-2022-06-30 00:00:00-2022-07-31 00:00:00开始取数.........\n", "Spend_time:4.270967721939087 s\n", "LY9139BB0MALBZ812-2022-06-30 00:00:00-2022-07-31 00:00:00取数完成.........\n", "LY9139BB0MALBZ812-2022-07-31 00:00:00-2022-08-31 00:00:00开始取数.........\n", "Spend_time:3.665022611618042 s\n", "LY9139BB0MALBZ812-2022-07-31 00:00:00-2022-08-31 00:00:00取数完成.........\n", "LY9139BB0MALBZ812-2022-08-31 00:00:00-2022-09-30 00:00:00开始取数.........\n", "Spend_time:2.0501935482025146 s\n", "LY9139BB0MALBZ812-2022-08-31 00:00:00-2022-09-30 00:00:00取数完成.........\n", "LY9139BB0MALBZ812-2022-09-30 00:00:00-2022-10-31 00:00:00开始取数.........\n", "Spend_time:2.8660261631011963 s\n", "LY9139BB0MALBZ812-2022-09-30 00:00:00-2022-10-31 00:00:00取数完成.........\n", "LY9139BB0MALBZ812-2022-10-31 00:00:00-2022-11-30 00:00:00开始取数.........\n", "Spend_time:2.7570114135742188 s\n", "LY9139BB0MALBZ812-2022-10-31 00:00:00-2022-11-30 00:00:00取数完成.........\n", "LY9139BB0MALBZ812-2022-11-30 00:00:00-2022-12-31 00:00:00开始取数.........\n", "Spend_time:0.09460902214050293 s\n", "LY9139BB0MALBZ812-2022-11-30 00:00:00-2022-12-31 00:00:00取数完成.........\n", "LY9139BB1MALBZ429-2022-01-31 00:00:00-2022-02-28 00:00:00开始取数.........\n", "Spend_time:1.7595841884613037 s\n", "LY9139BB1MALBZ429-2022-01-31 00:00:00-2022-02-28 00:00:00取数完成.........\n", "LY9139BB1MALBZ429-2022-02-28 00:00:00-2022-03-31 00:00:00开始取数.........\n", "Spend_time:4.192970275878906 s\n", "LY9139BB1MALBZ429-2022-02-28 00:00:00-2022-03-31 00:00:00取数完成.........\n", "LY9139BB1MALBZ429-2022-03-31 00:00:00-2022-04-30 00:00:00开始取数.........\n", "Spend_time:3.1194050312042236 s\n", "LY9139BB1MALBZ429-2022-03-31 00:00:00-2022-04-30 00:00:00取数完成.........\n", "LY9139BB1MALBZ429-2022-04-30 00:00:00-2022-05-31 00:00:00开始取数.........\n", "Spend_time:6.36001992225647 s\n", "LY9139BB1MALBZ429-2022-04-30 00:00:00-2022-05-31 00:00:00取数完成.........\n", "LY9139BB1MALBZ429-2022-05-31 00:00:00-2022-06-30 00:00:00开始取数.........\n", "Spend_time:3.643177032470703 s\n", "LY9139BB1MALBZ429-2022-05-31 00:00:00-2022-06-30 00:00:00取数完成.........\n", "LY9139BB1MALBZ429-2022-06-30 00:00:00-2022-07-31 00:00:00开始取数.........\n", "Spend_time:5.323202610015869 s\n", "LY9139BB1MALBZ429-2022-06-30 00:00:00-2022-07-31 00:00:00取数完成.........\n", "LY9139BB1MALBZ429-2022-07-31 00:00:00-2022-08-31 00:00:00开始取数.........\n", "Spend_time:3.313394784927368 s\n", "LY9139BB1MALBZ429-2022-07-31 00:00:00-2022-08-31 00:00:00取数完成.........\n", "LY9139BB1MALBZ429-2022-08-31 00:00:00-2022-09-30 00:00:00开始取数.........\n", "Spend_time:3.901059627532959 s\n", "LY9139BB1MALBZ429-2022-08-31 00:00:00-2022-09-30 00:00:00取数完成.........\n", "LY9139BB1MALBZ429-2022-09-30 00:00:00-2022-10-31 00:00:00开始取数.........\n", "Spend_time:5.970439434051514 s\n", "LY9139BB1MALBZ429-2022-09-30 00:00:00-2022-10-31 00:00:00取数完成.........\n", "LY9139BB1MALBZ429-2022-10-31 00:00:00-2022-11-30 00:00:00开始取数.........\n", "Spend_time:5.009822368621826 s\n", "LY9139BB1MALBZ429-2022-10-31 00:00:00-2022-11-30 00:00:00取数完成.........\n", "LY9139BB1MALBZ429-2022-11-30 00:00:00-2022-12-31 00:00:00开始取数.........\n", "Spend_time:0.2882242202758789 s\n", "LY9139BB1MALBZ429-2022-11-30 00:00:00-2022-12-31 00:00:00取数完成.........\n", "LY9139BB1MALBZ799-2022-01-31 00:00:00-2022-02-28 00:00:00开始取数.........\n", "Traceback (most recent call last):\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/ZlwlAlgosCommon/impl/DBHbase.py\", line 57, in page_query\n", " self.cursor.execute(new_sql)\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/cursor.py\", line 224, in execute\n", " results = self._connection._client.prepare_and_execute(\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/avatica/client.py\", line 461, in prepare_and_execute\n", " response_data = self._apply(request, 'ExecuteResponse')\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/avatica/client.py\", line 227, in _apply\n", " parse_error_protobuf(response_body)\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/avatica/client.py\", line 127, in parse_error_protobuf\n", " parse_and_raise_sql_error(err.error_message)\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/avatica/client.py\", line 103, in parse_and_raise_sql_error\n", " raise_sql_error(int(code), sqlstate, message)\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/avatica/client.py\", line 96, in raise_sql_error\n", " raise errors.InternalError(message, code, sqlstate)\n", "phoenixdb.errors.InternalError: ('ResultSet is closed.', 1101, 'XCL01', None)\n", "\n", "---------WARNING: HBASE 获取数据出现异常, 开始第1次重试....\n", "连接hbase数据库\n", "连接hbase数据库 成功\n", "Spend_time:3.816551923751831 s\n", "LY9139BB1MALBZ799-2022-01-31 00:00:00-2022-02-28 00:00:00取数完成.........\n", "LY9139BB1MALBZ799-2022-02-28 00:00:00-2022-03-31 00:00:00开始取数.........\n", "Spend_time:2.888317584991455 s\n", "LY9139BB1MALBZ799-2022-02-28 00:00:00-2022-03-31 00:00:00取数完成.........\n", "LY9139BB1MALBZ799-2022-03-31 00:00:00-2022-04-30 00:00:00开始取数.........\n", "Spend_time:4.084564924240112 s\n", "LY9139BB1MALBZ799-2022-03-31 00:00:00-2022-04-30 00:00:00取数完成.........\n", "LY9139BB1MALBZ799-2022-04-30 00:00:00-2022-05-31 00:00:00开始取数.........\n", "Spend_time:5.242894887924194 s\n", "LY9139BB1MALBZ799-2022-04-30 00:00:00-2022-05-31 00:00:00取数完成.........\n", "LY9139BB1MALBZ799-2022-05-31 00:00:00-2022-06-30 00:00:00开始取数.........\n", "Spend_time:3.6013200283050537 s\n", "LY9139BB1MALBZ799-2022-05-31 00:00:00-2022-06-30 00:00:00取数完成.........\n", "LY9139BB1MALBZ799-2022-06-30 00:00:00-2022-07-31 00:00:00开始取数.........\n", "Spend_time:3.7333714962005615 s\n", "LY9139BB1MALBZ799-2022-06-30 00:00:00-2022-07-31 00:00:00取数完成.........\n", "LY9139BB1MALBZ799-2022-07-31 00:00:00-2022-08-31 00:00:00开始取数.........\n", "Spend_time:2.98766827583313 s\n", "LY9139BB1MALBZ799-2022-07-31 00:00:00-2022-08-31 00:00:00取数完成.........\n", "LY9139BB1MALBZ799-2022-08-31 00:00:00-2022-09-30 00:00:00开始取数.........\n", "Spend_time:2.401029348373413 s\n", "LY9139BB1MALBZ799-2022-08-31 00:00:00-2022-09-30 00:00:00取数完成.........\n", "LY9139BB1MALBZ799-2022-09-30 00:00:00-2022-10-31 00:00:00开始取数.........\n", "Spend_time:4.283994436264038 s\n", "LY9139BB1MALBZ799-2022-09-30 00:00:00-2022-10-31 00:00:00取数完成.........\n", "LY9139BB1MALBZ799-2022-10-31 00:00:00-2022-11-30 00:00:00开始取数.........\n", "Spend_time:5.294934511184692 s\n", "LY9139BB1MALBZ799-2022-10-31 00:00:00-2022-11-30 00:00:00取数完成.........\n", "LY9139BB1MALBZ799-2022-11-30 00:00:00-2022-12-31 00:00:00开始取数.........\n", "Spend_time:0.55426025390625 s\n", "LY9139BB1MALBZ799-2022-11-30 00:00:00-2022-12-31 00:00:00取数完成.........\n", "LY9139BB1MALBZ804-2022-01-31 00:00:00-2022-02-28 00:00:00开始取数.........\n", "Spend_time:3.616370439529419 s\n", "LY9139BB1MALBZ804-2022-01-31 00:00:00-2022-02-28 00:00:00取数完成.........\n", "LY9139BB1MALBZ804-2022-02-28 00:00:00-2022-03-31 00:00:00开始取数.........\n", "Spend_time:6.477369546890259 s\n", "LY9139BB1MALBZ804-2022-02-28 00:00:00-2022-03-31 00:00:00取数完成.........\n", "LY9139BB1MALBZ804-2022-03-31 00:00:00-2022-04-30 00:00:00开始取数.........\n", "Spend_time:4.009035348892212 s\n", "LY9139BB1MALBZ804-2022-03-31 00:00:00-2022-04-30 00:00:00取数完成.........\n", "LY9139BB1MALBZ804-2022-04-30 00:00:00-2022-05-31 00:00:00开始取数.........\n", "Spend_time:4.3239240646362305 s\n", "LY9139BB1MALBZ804-2022-04-30 00:00:00-2022-05-31 00:00:00取数完成.........\n", "LY9139BB1MALBZ804-2022-05-31 00:00:00-2022-06-30 00:00:00开始取数.........\n", "Spend_time:5.782482385635376 s\n", "LY9139BB1MALBZ804-2022-05-31 00:00:00-2022-06-30 00:00:00取数完成.........\n", "LY9139BB1MALBZ804-2022-06-30 00:00:00-2022-07-31 00:00:00开始取数.........\n", "Spend_time:5.860889196395874 s\n", "LY9139BB1MALBZ804-2022-06-30 00:00:00-2022-07-31 00:00:00取数完成.........\n", "LY9139BB1MALBZ804-2022-07-31 00:00:00-2022-08-31 00:00:00开始取数.........\n", "Spend_time:5.338232755661011 s\n", "LY9139BB1MALBZ804-2022-07-31 00:00:00-2022-08-31 00:00:00取数完成.........\n", "LY9139BB1MALBZ804-2022-08-31 00:00:00-2022-09-30 00:00:00开始取数.........\n", "Spend_time:3.6578481197357178 s\n", "LY9139BB1MALBZ804-2022-08-31 00:00:00-2022-09-30 00:00:00取数完成.........\n", "LY9139BB1MALBZ804-2022-09-30 00:00:00-2022-10-31 00:00:00开始取数.........\n", "Spend_time:3.7559568881988525 s\n", "LY9139BB1MALBZ804-2022-09-30 00:00:00-2022-10-31 00:00:00取数完成.........\n", "LY9139BB1MALBZ804-2022-10-31 00:00:00-2022-11-30 00:00:00开始取数.........\n", "Spend_time:4.330792188644409 s\n", "LY9139BB1MALBZ804-2022-10-31 00:00:00-2022-11-30 00:00:00取数完成.........\n", "LY9139BB1MALBZ804-2022-11-30 00:00:00-2022-12-31 00:00:00开始取数.........\n", "Spend_time:0.07634258270263672 s\n", "LY9139BB1MALBZ804-2022-11-30 00:00:00-2022-12-31 00:00:00取数完成.........\n", "LY9139BB2MALBZ424-2022-01-31 00:00:00-2022-02-28 00:00:00开始取数.........\n", "Spend_time:1.6688144207000732 s\n", "LY9139BB2MALBZ424-2022-01-31 00:00:00-2022-02-28 00:00:00取数完成.........\n", "LY9139BB2MALBZ424-2022-02-28 00:00:00-2022-03-31 00:00:00开始取数.........\n", "Spend_time:3.9465904235839844 s\n", "LY9139BB2MALBZ424-2022-02-28 00:00:00-2022-03-31 00:00:00取数完成.........\n", "LY9139BB2MALBZ424-2022-03-31 00:00:00-2022-04-30 00:00:00开始取数.........\n", "Spend_time:6.1767189502716064 s\n", "LY9139BB2MALBZ424-2022-03-31 00:00:00-2022-04-30 00:00:00取数完成.........\n", "LY9139BB2MALBZ424-2022-04-30 00:00:00-2022-05-31 00:00:00开始取数.........\n", "Spend_time:5.705340623855591 s\n", "LY9139BB2MALBZ424-2022-04-30 00:00:00-2022-05-31 00:00:00取数完成.........\n", "LY9139BB2MALBZ424-2022-05-31 00:00:00-2022-06-30 00:00:00开始取数.........\n", "Spend_time:3.280695915222168 s\n", "LY9139BB2MALBZ424-2022-05-31 00:00:00-2022-06-30 00:00:00取数完成.........\n", "LY9139BB2MALBZ424-2022-06-30 00:00:00-2022-07-31 00:00:00开始取数.........\n", "Spend_time:4.513644456863403 s\n", "LY9139BB2MALBZ424-2022-06-30 00:00:00-2022-07-31 00:00:00取数完成.........\n", "LY9139BB2MALBZ424-2022-07-31 00:00:00-2022-08-31 00:00:00开始取数.........\n", "Spend_time:6.520406007766724 s\n", "LY9139BB2MALBZ424-2022-07-31 00:00:00-2022-08-31 00:00:00取数完成.........\n", "LY9139BB2MALBZ424-2022-08-31 00:00:00-2022-09-30 00:00:00开始取数.........\n", "Spend_time:6.157524585723877 s\n", "LY9139BB2MALBZ424-2022-08-31 00:00:00-2022-09-30 00:00:00取数完成.........\n", "LY9139BB2MALBZ424-2022-09-30 00:00:00-2022-10-31 00:00:00开始取数.........\n", "Spend_time:6.396167039871216 s\n", "LY9139BB2MALBZ424-2022-09-30 00:00:00-2022-10-31 00:00:00取数完成.........\n", "LY9139BB2MALBZ424-2022-10-31 00:00:00-2022-11-30 00:00:00开始取数.........\n", "Spend_time:8.955356121063232 s\n", "LY9139BB2MALBZ424-2022-10-31 00:00:00-2022-11-30 00:00:00取数完成.........\n", "LY9139BB2MALBZ424-2022-11-30 00:00:00-2022-12-31 00:00:00开始取数.........\n", "Spend_time:0.3754458427429199 s\n", "LY9139BB2MALBZ424-2022-11-30 00:00:00-2022-12-31 00:00:00取数完成.........\n", "LY9139BB2MALBZ505-2022-01-31 00:00:00-2022-02-28 00:00:00开始取数.........\n", "Spend_time:1.5130486488342285 s\n", "LY9139BB2MALBZ505-2022-01-31 00:00:00-2022-02-28 00:00:00取数完成.........\n", "LY9139BB2MALBZ505-2022-02-28 00:00:00-2022-03-31 00:00:00开始取数.........\n", "Spend_time:2.6675875186920166 s\n", "LY9139BB2MALBZ505-2022-02-28 00:00:00-2022-03-31 00:00:00取数完成.........\n", "LY9139BB2MALBZ505-2022-03-31 00:00:00-2022-04-30 00:00:00开始取数.........\n", "Spend_time:4.023674964904785 s\n", "LY9139BB2MALBZ505-2022-03-31 00:00:00-2022-04-30 00:00:00取数完成.........\n", "LY9139BB2MALBZ505-2022-04-30 00:00:00-2022-05-31 00:00:00开始取数.........\n", "Spend_time:3.4773061275482178 s\n", "LY9139BB2MALBZ505-2022-04-30 00:00:00-2022-05-31 00:00:00取数完成.........\n", "LY9139BB2MALBZ505-2022-05-31 00:00:00-2022-06-30 00:00:00开始取数.........\n", "Spend_time:2.7339975833892822 s\n", "LY9139BB2MALBZ505-2022-05-31 00:00:00-2022-06-30 00:00:00取数完成.........\n", "LY9139BB2MALBZ505-2022-06-30 00:00:00-2022-07-31 00:00:00开始取数.........\n", "Spend_time:2.664240837097168 s\n", "LY9139BB2MALBZ505-2022-06-30 00:00:00-2022-07-31 00:00:00取数完成.........\n", "LY9139BB2MALBZ505-2022-07-31 00:00:00-2022-08-31 00:00:00开始取数.........\n", "Spend_time:2.7643396854400635 s\n", "LY9139BB2MALBZ505-2022-07-31 00:00:00-2022-08-31 00:00:00取数完成.........\n", "LY9139BB2MALBZ505-2022-08-31 00:00:00-2022-09-30 00:00:00开始取数.........\n", "Spend_time:3.5120396614074707 s\n", "LY9139BB2MALBZ505-2022-08-31 00:00:00-2022-09-30 00:00:00取数完成.........\n", "LY9139BB2MALBZ505-2022-09-30 00:00:00-2022-10-31 00:00:00开始取数.........\n", "Spend_time:3.9689178466796875 s\n", "LY9139BB2MALBZ505-2022-09-30 00:00:00-2022-10-31 00:00:00取数完成.........\n", "LY9139BB2MALBZ505-2022-10-31 00:00:00-2022-11-30 00:00:00开始取数.........\n", "Spend_time:4.131394863128662 s\n", "LY9139BB2MALBZ505-2022-10-31 00:00:00-2022-11-30 00:00:00取数完成.........\n", "LY9139BB2MALBZ505-2022-11-30 00:00:00-2022-12-31 00:00:00开始取数.........\n", "Spend_time:0.30150723457336426 s\n", "LY9139BB2MALBZ505-2022-11-30 00:00:00-2022-12-31 00:00:00取数完成.........\n", "LY9139BB2MALBZ794-2022-01-31 00:00:00-2022-02-28 00:00:00开始取数.........\n", "Spend_time:5.57964825630188 s\n", "LY9139BB2MALBZ794-2022-01-31 00:00:00-2022-02-28 00:00:00取数完成.........\n", "LY9139BB2MALBZ794-2022-02-28 00:00:00-2022-03-31 00:00:00开始取数.........\n", "Spend_time:4.2533323764801025 s\n", "LY9139BB2MALBZ794-2022-02-28 00:00:00-2022-03-31 00:00:00取数完成.........\n", "LY9139BB2MALBZ794-2022-03-31 00:00:00-2022-04-30 00:00:00开始取数.........\n", "Spend_time:5.556216478347778 s\n", "LY9139BB2MALBZ794-2022-03-31 00:00:00-2022-04-30 00:00:00取数完成.........\n", "LY9139BB2MALBZ794-2022-04-30 00:00:00-2022-05-31 00:00:00开始取数.........\n", "Spend_time:4.87896466255188 s\n", "LY9139BB2MALBZ794-2022-04-30 00:00:00-2022-05-31 00:00:00取数完成.........\n", "LY9139BB2MALBZ794-2022-05-31 00:00:00-2022-06-30 00:00:00开始取数.........\n", "Spend_time:6.781680107116699 s\n", "LY9139BB2MALBZ794-2022-05-31 00:00:00-2022-06-30 00:00:00取数完成.........\n", "LY9139BB2MALBZ794-2022-06-30 00:00:00-2022-07-31 00:00:00开始取数.........\n", "Spend_time:5.89710259437561 s\n", "LY9139BB2MALBZ794-2022-06-30 00:00:00-2022-07-31 00:00:00取数完成.........\n", "LY9139BB2MALBZ794-2022-07-31 00:00:00-2022-08-31 00:00:00开始取数.........\n", "Spend_time:7.469214916229248 s\n", "LY9139BB2MALBZ794-2022-07-31 00:00:00-2022-08-31 00:00:00取数完成.........\n", "LY9139BB2MALBZ794-2022-08-31 00:00:00-2022-09-30 00:00:00开始取数.........\n", "Spend_time:4.932267427444458 s\n", "LY9139BB2MALBZ794-2022-08-31 00:00:00-2022-09-30 00:00:00取数完成.........\n", "LY9139BB2MALBZ794-2022-09-30 00:00:00-2022-10-31 00:00:00开始取数.........\n", "Spend_time:3.9033937454223633 s\n", "LY9139BB2MALBZ794-2022-09-30 00:00:00-2022-10-31 00:00:00取数完成.........\n", "LY9139BB2MALBZ794-2022-10-31 00:00:00-2022-11-30 00:00:00开始取数.........\n", "Spend_time:5.112104892730713 s\n", "LY9139BB2MALBZ794-2022-10-31 00:00:00-2022-11-30 00:00:00取数完成.........\n", "LY9139BB2MALBZ794-2022-11-30 00:00:00-2022-12-31 00:00:00开始取数.........\n", "Spend_time:0.3106567859649658 s\n", "LY9139BB2MALBZ794-2022-11-30 00:00:00-2022-12-31 00:00:00取数完成.........\n", "LY9139BB3MALBZ318-2022-01-31 00:00:00-2022-02-28 00:00:00开始取数.........\n", "Spend_time:1.481856346130371 s\n", "LY9139BB3MALBZ318-2022-01-31 00:00:00-2022-02-28 00:00:00取数完成.........\n", "LY9139BB3MALBZ318-2022-02-28 00:00:00-2022-03-31 00:00:00开始取数.........\n", "Spend_time:2.3312880992889404 s\n", "LY9139BB3MALBZ318-2022-02-28 00:00:00-2022-03-31 00:00:00取数完成.........\n", "LY9139BB3MALBZ318-2022-03-31 00:00:00-2022-04-30 00:00:00开始取数.........\n", "Spend_time:5.386065721511841 s\n", "LY9139BB3MALBZ318-2022-03-31 00:00:00-2022-04-30 00:00:00取数完成.........\n", "LY9139BB3MALBZ318-2022-04-30 00:00:00-2022-05-31 00:00:00开始取数.........\n", "Spend_time:3.3894293308258057 s\n", "LY9139BB3MALBZ318-2022-04-30 00:00:00-2022-05-31 00:00:00取数完成.........\n", "LY9139BB3MALBZ318-2022-05-31 00:00:00-2022-06-30 00:00:00开始取数.........\n", "Spend_time:3.1355128288269043 s\n", "LY9139BB3MALBZ318-2022-05-31 00:00:00-2022-06-30 00:00:00取数完成.........\n", "LY9139BB3MALBZ318-2022-06-30 00:00:00-2022-07-31 00:00:00开始取数.........\n", "Spend_time:3.4807164669036865 s\n", "LY9139BB3MALBZ318-2022-06-30 00:00:00-2022-07-31 00:00:00取数完成.........\n", "LY9139BB3MALBZ318-2022-07-31 00:00:00-2022-08-31 00:00:00开始取数.........\n", "Traceback (most recent call last):\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/ZlwlAlgosCommon/impl/DBHbase.py\", line 58, in page_query\n", " last_rows = self.cursor.fetchall()\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/cursor.py\", line 338, in fetchall\n", " row = self.fetchone()\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/cursor.py\", line 320, in fetchone\n", " self._fetch_next_frame()\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/cursor.py\", line 160, in _fetch_next_frame\n", " frame = self._connection._client.fetch(\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/avatica/client.py\", line 595, in fetch\n", " response_data = self._apply(request)\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/avatica/client.py\", line 227, in _apply\n", " parse_error_protobuf(response_body)\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/avatica/client.py\", line 127, in parse_error_protobuf\n", " parse_and_raise_sql_error(err.error_message)\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/avatica/client.py\", line 103, in parse_and_raise_sql_error\n", " raise_sql_error(int(code), sqlstate, message)\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/avatica/client.py\", line 96, in raise_sql_error\n", " raise errors.InternalError(message, code, sqlstate)\n", "phoenixdb.errors.InternalError: ('ResultSet is closed.', 1101, 'XCL01', None)\n", "\n", "---------WARNING: HBASE 获取数据出现异常, 开始第1次重试....\n", "连接hbase数据库\n", "连接hbase数据库 成功\n", "Spend_time:1.5744335651397705 s\n", "LY9139BB3MALBZ318-2022-07-31 00:00:00-2022-08-31 00:00:00取数完成.........\n", "LY9139BB3MALBZ318-2022-08-31 00:00:00-2022-09-30 00:00:00开始取数.........\n", "Spend_time:3.561105489730835 s\n", "LY9139BB3MALBZ318-2022-08-31 00:00:00-2022-09-30 00:00:00取数完成.........\n", "LY9139BB3MALBZ318-2022-09-30 00:00:00-2022-10-31 00:00:00开始取数.........\n", "Spend_time:3.8282272815704346 s\n", "LY9139BB3MALBZ318-2022-09-30 00:00:00-2022-10-31 00:00:00取数完成.........\n", "LY9139BB3MALBZ318-2022-10-31 00:00:00-2022-11-30 00:00:00开始取数.........\n", "Spend_time:3.6842944622039795 s\n", "LY9139BB3MALBZ318-2022-10-31 00:00:00-2022-11-30 00:00:00取数完成.........\n", "LY9139BB3MALBZ318-2022-11-30 00:00:00-2022-12-31 00:00:00开始取数.........\n", "Spend_time:0.475144624710083 s\n", "LY9139BB3MALBZ318-2022-11-30 00:00:00-2022-12-31 00:00:00取数完成.........\n", "LY9139BB3MALBZ805-2022-01-31 00:00:00-2022-02-28 00:00:00开始取数.........\n", "Spend_time:2.8097336292266846 s\n", "LY9139BB3MALBZ805-2022-01-31 00:00:00-2022-02-28 00:00:00取数完成.........\n", "LY9139BB3MALBZ805-2022-02-28 00:00:00-2022-03-31 00:00:00开始取数.........\n", "Spend_time:4.286270380020142 s\n", "LY9139BB3MALBZ805-2022-02-28 00:00:00-2022-03-31 00:00:00取数完成.........\n", "LY9139BB3MALBZ805-2022-03-31 00:00:00-2022-04-30 00:00:00开始取数.........\n", "Spend_time:4.4063334465026855 s\n", "LY9139BB3MALBZ805-2022-03-31 00:00:00-2022-04-30 00:00:00取数完成.........\n", "LY9139BB3MALBZ805-2022-04-30 00:00:00-2022-05-31 00:00:00开始取数.........\n", "Spend_time:4.748835563659668 s\n", "LY9139BB3MALBZ805-2022-04-30 00:00:00-2022-05-31 00:00:00取数完成.........\n", "LY9139BB3MALBZ805-2022-05-31 00:00:00-2022-06-30 00:00:00开始取数.........\n", "Spend_time:3.9755494594573975 s\n", "LY9139BB3MALBZ805-2022-05-31 00:00:00-2022-06-30 00:00:00取数完成.........\n", "LY9139BB3MALBZ805-2022-06-30 00:00:00-2022-07-31 00:00:00开始取数.........\n", "Spend_time:4.450421094894409 s\n", "LY9139BB3MALBZ805-2022-06-30 00:00:00-2022-07-31 00:00:00取数完成.........\n", "LY9139BB3MALBZ805-2022-07-31 00:00:00-2022-08-31 00:00:00开始取数.........\n", "Spend_time:2.669431447982788 s\n", "LY9139BB3MALBZ805-2022-07-31 00:00:00-2022-08-31 00:00:00取数完成.........\n", "LY9139BB3MALBZ805-2022-08-31 00:00:00-2022-09-30 00:00:00开始取数.........\n", "Spend_time:2.2137720584869385 s\n", "LY9139BB3MALBZ805-2022-08-31 00:00:00-2022-09-30 00:00:00取数完成.........\n", "LY9139BB3MALBZ805-2022-09-30 00:00:00-2022-10-31 00:00:00开始取数.........\n", "Spend_time:5.427418231964111 s\n", "LY9139BB3MALBZ805-2022-09-30 00:00:00-2022-10-31 00:00:00取数完成.........\n", "LY9139BB3MALBZ805-2022-10-31 00:00:00-2022-11-30 00:00:00开始取数.........\n", "Spend_time:4.730316877365112 s\n", "LY9139BB3MALBZ805-2022-10-31 00:00:00-2022-11-30 00:00:00取数完成.........\n", "LY9139BB3MALBZ805-2022-11-30 00:00:00-2022-12-31 00:00:00开始取数.........\n", "Spend_time:0.2470386028289795 s\n", "LY9139BB3MALBZ805-2022-11-30 00:00:00-2022-12-31 00:00:00取数完成.........\n", "LY9139BB4MALBZ795-2022-01-31 00:00:00-2022-02-28 00:00:00开始取数.........\n", "Spend_time:4.307769060134888 s\n", "LY9139BB4MALBZ795-2022-01-31 00:00:00-2022-02-28 00:00:00取数完成.........\n", "LY9139BB4MALBZ795-2022-02-28 00:00:00-2022-03-31 00:00:00开始取数.........\n", "Spend_time:3.8035264015197754 s\n", "LY9139BB4MALBZ795-2022-02-28 00:00:00-2022-03-31 00:00:00取数完成.........\n", "LY9139BB4MALBZ795-2022-03-31 00:00:00-2022-04-30 00:00:00开始取数.........\n", "Spend_time:4.530833959579468 s\n", "LY9139BB4MALBZ795-2022-03-31 00:00:00-2022-04-30 00:00:00取数完成.........\n", "LY9139BB4MALBZ795-2022-04-30 00:00:00-2022-05-31 00:00:00开始取数.........\n", "Spend_time:5.222219228744507 s\n", "LY9139BB4MALBZ795-2022-04-30 00:00:00-2022-05-31 00:00:00取数完成.........\n", "LY9139BB4MALBZ795-2022-05-31 00:00:00-2022-06-30 00:00:00开始取数.........\n", "Spend_time:5.137901782989502 s\n", "LY9139BB4MALBZ795-2022-05-31 00:00:00-2022-06-30 00:00:00取数完成.........\n", "LY9139BB4MALBZ795-2022-06-30 00:00:00-2022-07-31 00:00:00开始取数.........\n", "Spend_time:5.291151762008667 s\n", "LY9139BB4MALBZ795-2022-06-30 00:00:00-2022-07-31 00:00:00取数完成.........\n", "LY9139BB4MALBZ795-2022-07-31 00:00:00-2022-08-31 00:00:00开始取数.........\n", "Spend_time:4.1232993602752686 s\n", "LY9139BB4MALBZ795-2022-07-31 00:00:00-2022-08-31 00:00:00取数完成.........\n", "LY9139BB4MALBZ795-2022-08-31 00:00:00-2022-09-30 00:00:00开始取数.........\n", "Spend_time:4.1603803634643555 s\n", "LY9139BB4MALBZ795-2022-08-31 00:00:00-2022-09-30 00:00:00取数完成.........\n", "LY9139BB4MALBZ795-2022-09-30 00:00:00-2022-10-31 00:00:00开始取数.........\n", "Spend_time:4.303589820861816 s\n", "LY9139BB4MALBZ795-2022-09-30 00:00:00-2022-10-31 00:00:00取数完成.........\n", "LY9139BB4MALBZ795-2022-10-31 00:00:00-2022-11-30 00:00:00开始取数.........\n", "Spend_time:3.374098062515259 s\n", "LY9139BB4MALBZ795-2022-10-31 00:00:00-2022-11-30 00:00:00取数完成.........\n", "LY9139BB4MALBZ795-2022-11-30 00:00:00-2022-12-31 00:00:00开始取数.........\n", "Spend_time:0.5588226318359375 s\n", "LY9139BB4MALBZ795-2022-11-30 00:00:00-2022-12-31 00:00:00取数完成.........\n", "LY9139BB4MALBZ800-2022-01-31 00:00:00-2022-02-28 00:00:00开始取数.........\n", "Spend_time:2.509244918823242 s\n", "LY9139BB4MALBZ800-2022-01-31 00:00:00-2022-02-28 00:00:00取数完成.........\n", "LY9139BB4MALBZ800-2022-02-28 00:00:00-2022-03-31 00:00:00开始取数.........\n", "Spend_time:4.5828962326049805 s\n", "LY9139BB4MALBZ800-2022-02-28 00:00:00-2022-03-31 00:00:00取数完成.........\n", "LY9139BB4MALBZ800-2022-03-31 00:00:00-2022-04-30 00:00:00开始取数.........\n", "Spend_time:2.817866086959839 s\n", "LY9139BB4MALBZ800-2022-03-31 00:00:00-2022-04-30 00:00:00取数完成.........\n", "LY9139BB4MALBZ800-2022-04-30 00:00:00-2022-05-31 00:00:00开始取数.........\n", "Spend_time:2.0049808025360107 s\n", "LY9139BB4MALBZ800-2022-04-30 00:00:00-2022-05-31 00:00:00取数完成.........\n", "LY9139BB4MALBZ800-2022-05-31 00:00:00-2022-06-30 00:00:00开始取数.........\n", "Spend_time:3.7584104537963867 s\n", "LY9139BB4MALBZ800-2022-05-31 00:00:00-2022-06-30 00:00:00取数完成.........\n", "LY9139BB4MALBZ800-2022-06-30 00:00:00-2022-07-31 00:00:00开始取数.........\n", "Spend_time:3.8462092876434326 s\n", "LY9139BB4MALBZ800-2022-06-30 00:00:00-2022-07-31 00:00:00取数完成.........\n", "LY9139BB4MALBZ800-2022-07-31 00:00:00-2022-08-31 00:00:00开始取数.........\n", "Spend_time:4.957748174667358 s\n", "LY9139BB4MALBZ800-2022-07-31 00:00:00-2022-08-31 00:00:00取数完成.........\n", "LY9139BB4MALBZ800-2022-08-31 00:00:00-2022-09-30 00:00:00开始取数.........\n", "Spend_time:4.294106721878052 s\n", "LY9139BB4MALBZ800-2022-08-31 00:00:00-2022-09-30 00:00:00取数完成.........\n", "LY9139BB4MALBZ800-2022-09-30 00:00:00-2022-10-31 00:00:00开始取数.........\n", "Spend_time:3.9217422008514404 s\n", "LY9139BB4MALBZ800-2022-09-30 00:00:00-2022-10-31 00:00:00取数完成.........\n", "LY9139BB4MALBZ800-2022-10-31 00:00:00-2022-11-30 00:00:00开始取数.........\n", "Spend_time:2.68336820602417 s\n", "LY9139BB4MALBZ800-2022-10-31 00:00:00-2022-11-30 00:00:00取数完成.........\n", "LY9139BB4MALBZ800-2022-11-30 00:00:00-2022-12-31 00:00:00开始取数.........\n", "Spend_time:0.05164480209350586 s\n", "LY9139BB4MALBZ800-2022-11-30 00:00:00-2022-12-31 00:00:00取数完成.........\n", "LY9139BB5MALBZ319-2022-01-31 00:00:00-2022-02-28 00:00:00开始取数.........\n", "Spend_time:0.20351219177246094 s\n", "LY9139BB5MALBZ319-2022-01-31 00:00:00-2022-02-28 00:00:00取数完成.........\n", "LY9139BB5MALBZ319-2022-02-28 00:00:00-2022-03-31 00:00:00开始取数.........\n", "Spend_time:0.8669939041137695 s\n", "LY9139BB5MALBZ319-2022-02-28 00:00:00-2022-03-31 00:00:00取数完成.........\n", "LY9139BB5MALBZ319-2022-03-31 00:00:00-2022-04-30 00:00:00开始取数.........\n", "Spend_time:2.596487522125244 s\n", "LY9139BB5MALBZ319-2022-03-31 00:00:00-2022-04-30 00:00:00取数完成.........\n", "LY9139BB5MALBZ319-2022-04-30 00:00:00-2022-05-31 00:00:00开始取数.........\n", "Spend_time:2.5294759273529053 s\n", "LY9139BB5MALBZ319-2022-04-30 00:00:00-2022-05-31 00:00:00取数完成.........\n", "LY9139BB5MALBZ319-2022-05-31 00:00:00-2022-06-30 00:00:00开始取数.........\n", "Spend_time:4.84563136100769 s\n", "LY9139BB5MALBZ319-2022-05-31 00:00:00-2022-06-30 00:00:00取数完成.........\n", "LY9139BB5MALBZ319-2022-06-30 00:00:00-2022-07-31 00:00:00开始取数.........\n", "Spend_time:3.6017799377441406 s\n", "LY9139BB5MALBZ319-2022-06-30 00:00:00-2022-07-31 00:00:00取数完成.........\n", "LY9139BB5MALBZ319-2022-07-31 00:00:00-2022-08-31 00:00:00开始取数.........\n", "Spend_time:4.9486987590789795 s\n", "LY9139BB5MALBZ319-2022-07-31 00:00:00-2022-08-31 00:00:00取数完成.........\n", "LY9139BB5MALBZ319-2022-08-31 00:00:00-2022-09-30 00:00:00开始取数.........\n", "Spend_time:1.4682788848876953 s\n", "LY9139BB5MALBZ319-2022-08-31 00:00:00-2022-09-30 00:00:00取数完成.........\n", "LY9139BB5MALBZ319-2022-09-30 00:00:00-2022-10-31 00:00:00开始取数.........\n", "Spend_time:4.532475471496582 s\n", "LY9139BB5MALBZ319-2022-09-30 00:00:00-2022-10-31 00:00:00取数完成.........\n", "LY9139BB5MALBZ319-2022-10-31 00:00:00-2022-11-30 00:00:00开始取数.........\n", "Spend_time:4.295026063919067 s\n", "LY9139BB5MALBZ319-2022-10-31 00:00:00-2022-11-30 00:00:00取数完成.........\n", "LY9139BB5MALBZ319-2022-11-30 00:00:00-2022-12-31 00:00:00开始取数.........\n", "Spend_time:0.19591760635375977 s\n", "LY9139BB5MALBZ319-2022-11-30 00:00:00-2022-12-31 00:00:00取数完成.........\n", "LY9139BB5MALBZ806-2022-01-31 00:00:00-2022-02-28 00:00:00开始取数.........\n", "Spend_time:1.1302647590637207 s\n", "LY9139BB5MALBZ806-2022-01-31 00:00:00-2022-02-28 00:00:00取数完成.........\n", "LY9139BB5MALBZ806-2022-02-28 00:00:00-2022-03-31 00:00:00开始取数.........\n", "Spend_time:5.636694431304932 s\n", "LY9139BB5MALBZ806-2022-02-28 00:00:00-2022-03-31 00:00:00取数完成.........\n", "LY9139BB5MALBZ806-2022-03-31 00:00:00-2022-04-30 00:00:00开始取数.........\n", "Spend_time:4.178189992904663 s\n", "LY9139BB5MALBZ806-2022-03-31 00:00:00-2022-04-30 00:00:00取数完成.........\n", "LY9139BB5MALBZ806-2022-04-30 00:00:00-2022-05-31 00:00:00开始取数.........\n", "Spend_time:4.071834087371826 s\n", "LY9139BB5MALBZ806-2022-04-30 00:00:00-2022-05-31 00:00:00取数完成.........\n", "LY9139BB5MALBZ806-2022-05-31 00:00:00-2022-06-30 00:00:00开始取数.........\n", "Spend_time:5.103410720825195 s\n", "LY9139BB5MALBZ806-2022-05-31 00:00:00-2022-06-30 00:00:00取数完成.........\n", "LY9139BB5MALBZ806-2022-06-30 00:00:00-2022-07-31 00:00:00开始取数.........\n", "Spend_time:4.870059490203857 s\n", "LY9139BB5MALBZ806-2022-06-30 00:00:00-2022-07-31 00:00:00取数完成.........\n", "LY9139BB5MALBZ806-2022-07-31 00:00:00-2022-08-31 00:00:00开始取数.........\n", "Spend_time:5.931130647659302 s\n", "LY9139BB5MALBZ806-2022-07-31 00:00:00-2022-08-31 00:00:00取数完成.........\n", "LY9139BB5MALBZ806-2022-08-31 00:00:00-2022-09-30 00:00:00开始取数.........\n", "Spend_time:3.233846426010132 s\n", "LY9139BB5MALBZ806-2022-08-31 00:00:00-2022-09-30 00:00:00取数完成.........\n", "LY9139BB5MALBZ806-2022-09-30 00:00:00-2022-10-31 00:00:00开始取数.........\n", "Spend_time:6.432384014129639 s\n", "LY9139BB5MALBZ806-2022-09-30 00:00:00-2022-10-31 00:00:00取数完成.........\n", "LY9139BB5MALBZ806-2022-10-31 00:00:00-2022-11-30 00:00:00开始取数.........\n", "Spend_time:3.318720579147339 s\n", "LY9139BB5MALBZ806-2022-10-31 00:00:00-2022-11-30 00:00:00取数完成.........\n", "LY9139BB5MALBZ806-2022-11-30 00:00:00-2022-12-31 00:00:00开始取数.........\n", "Spend_time:0.3926732540130615 s\n", "LY9139BB5MALBZ806-2022-11-30 00:00:00-2022-12-31 00:00:00取数完成.........\n", "LY9139BB6MALBZ426-2022-01-31 00:00:00-2022-02-28 00:00:00开始取数.........\n", "Spend_time:1.4711277484893799 s\n", "LY9139BB6MALBZ426-2022-01-31 00:00:00-2022-02-28 00:00:00取数完成.........\n", "LY9139BB6MALBZ426-2022-02-28 00:00:00-2022-03-31 00:00:00开始取数.........\n", "Spend_time:5.6798179149627686 s\n", "LY9139BB6MALBZ426-2022-02-28 00:00:00-2022-03-31 00:00:00取数完成.........\n", "LY9139BB6MALBZ426-2022-03-31 00:00:00-2022-04-30 00:00:00开始取数.........\n", "Spend_time:6.088750123977661 s\n", "LY9139BB6MALBZ426-2022-03-31 00:00:00-2022-04-30 00:00:00取数完成.........\n", "LY9139BB6MALBZ426-2022-04-30 00:00:00-2022-05-31 00:00:00开始取数.........\n", "Spend_time:3.6996893882751465 s\n", "LY9139BB6MALBZ426-2022-04-30 00:00:00-2022-05-31 00:00:00取数完成.........\n", "LY9139BB6MALBZ426-2022-05-31 00:00:00-2022-06-30 00:00:00开始取数.........\n", "Spend_time:3.1231436729431152 s\n", "LY9139BB6MALBZ426-2022-05-31 00:00:00-2022-06-30 00:00:00取数完成.........\n", "LY9139BB6MALBZ426-2022-06-30 00:00:00-2022-07-31 00:00:00开始取数.........\n", "Spend_time:2.736205577850342 s\n", "LY9139BB6MALBZ426-2022-06-30 00:00:00-2022-07-31 00:00:00取数完成.........\n", "LY9139BB6MALBZ426-2022-07-31 00:00:00-2022-08-31 00:00:00开始取数.........\n", "Traceback (most recent call last):\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/ZlwlAlgosCommon/impl/DBHbase.py\", line 58, in page_query\n", " last_rows = self.cursor.fetchall()\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/cursor.py\", line 338, in fetchall\n", " row = self.fetchone()\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/cursor.py\", line 320, in fetchone\n", " self._fetch_next_frame()\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/cursor.py\", line 160, in _fetch_next_frame\n", " frame = self._connection._client.fetch(\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/avatica/client.py\", line 595, in fetch\n", " response_data = self._apply(request)\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/avatica/client.py\", line 227, in _apply\n", " parse_error_protobuf(response_body)\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/avatica/client.py\", line 127, in parse_error_protobuf\n", " parse_and_raise_sql_error(err.error_message)\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/avatica/client.py\", line 103, in parse_and_raise_sql_error\n", " raise_sql_error(int(code), sqlstate, message)\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/avatica/client.py\", line 96, in raise_sql_error\n", " raise errors.InternalError(message, code, sqlstate)\n", "phoenixdb.errors.InternalError: ('ResultSet is closed.', 1101, 'XCL01', None)\n", "\n", "---------WARNING: HBASE 获取数据出现异常, 开始第1次重试....\n", "连接hbase数据库\n", "连接hbase数据库 成功\n", "Spend_time:3.649458646774292 s\n", "LY9139BB6MALBZ426-2022-07-31 00:00:00-2022-08-31 00:00:00取数完成.........\n", "LY9139BB6MALBZ426-2022-08-31 00:00:00-2022-09-30 00:00:00开始取数.........\n", "Spend_time:3.23287034034729 s\n", "LY9139BB6MALBZ426-2022-08-31 00:00:00-2022-09-30 00:00:00取数完成.........\n", "LY9139BB6MALBZ426-2022-09-30 00:00:00-2022-10-31 00:00:00开始取数.........\n", "Spend_time:4.464540481567383 s\n", "LY9139BB6MALBZ426-2022-09-30 00:00:00-2022-10-31 00:00:00取数完成.........\n", "LY9139BB6MALBZ426-2022-10-31 00:00:00-2022-11-30 00:00:00开始取数.........\n", "Spend_time:5.924854278564453 s\n", "LY9139BB6MALBZ426-2022-10-31 00:00:00-2022-11-30 00:00:00取数完成.........\n", "LY9139BB6MALBZ426-2022-11-30 00:00:00-2022-12-31 00:00:00开始取数.........\n", "Spend_time:0.2722947597503662 s\n", "LY9139BB6MALBZ426-2022-11-30 00:00:00-2022-12-31 00:00:00取数完成.........\n", "LY9139BB6MALBZ796-2022-01-31 00:00:00-2022-02-28 00:00:00开始取数.........\n", "Spend_time:3.6465022563934326 s\n", "LY9139BB6MALBZ796-2022-01-31 00:00:00-2022-02-28 00:00:00取数完成.........\n", "LY9139BB6MALBZ796-2022-02-28 00:00:00-2022-03-31 00:00:00开始取数.........\n", "Spend_time:3.4773313999176025 s\n", "LY9139BB6MALBZ796-2022-02-28 00:00:00-2022-03-31 00:00:00取数完成.........\n", "LY9139BB6MALBZ796-2022-03-31 00:00:00-2022-04-30 00:00:00开始取数.........\n", "Spend_time:2.6496739387512207 s\n", "LY9139BB6MALBZ796-2022-03-31 00:00:00-2022-04-30 00:00:00取数完成.........\n", "LY9139BB6MALBZ796-2022-04-30 00:00:00-2022-05-31 00:00:00开始取数.........\n", "Spend_time:2.9299471378326416 s\n", "LY9139BB6MALBZ796-2022-04-30 00:00:00-2022-05-31 00:00:00取数完成.........\n", "LY9139BB6MALBZ796-2022-05-31 00:00:00-2022-06-30 00:00:00开始取数.........\n", "Spend_time:6.156567573547363 s\n", "LY9139BB6MALBZ796-2022-05-31 00:00:00-2022-06-30 00:00:00取数完成.........\n", "LY9139BB6MALBZ796-2022-06-30 00:00:00-2022-07-31 00:00:00开始取数.........\n", "Spend_time:4.817704677581787 s\n", "LY9139BB6MALBZ796-2022-06-30 00:00:00-2022-07-31 00:00:00取数完成.........\n", "LY9139BB6MALBZ796-2022-07-31 00:00:00-2022-08-31 00:00:00开始取数.........\n", "Spend_time:4.885371208190918 s\n", "LY9139BB6MALBZ796-2022-07-31 00:00:00-2022-08-31 00:00:00取数完成.........\n", "LY9139BB6MALBZ796-2022-08-31 00:00:00-2022-09-30 00:00:00开始取数.........\n", "Spend_time:4.775119781494141 s\n", "LY9139BB6MALBZ796-2022-08-31 00:00:00-2022-09-30 00:00:00取数完成.........\n", "LY9139BB6MALBZ796-2022-09-30 00:00:00-2022-10-31 00:00:00开始取数.........\n", "Spend_time:4.713082551956177 s\n", "LY9139BB6MALBZ796-2022-09-30 00:00:00-2022-10-31 00:00:00取数完成.........\n", "LY9139BB6MALBZ796-2022-10-31 00:00:00-2022-11-30 00:00:00开始取数.........\n", "Spend_time:4.116806983947754 s\n", "LY9139BB6MALBZ796-2022-10-31 00:00:00-2022-11-30 00:00:00取数完成.........\n", "LY9139BB6MALBZ796-2022-11-30 00:00:00-2022-12-31 00:00:00开始取数.........\n", "Spend_time:0.6090433597564697 s\n", "LY9139BB6MALBZ796-2022-11-30 00:00:00-2022-12-31 00:00:00取数完成.........\n", "LY9139BB6MALBZ801-2022-01-31 00:00:00-2022-02-28 00:00:00开始取数.........\n", "Spend_time:0.9815592765808105 s\n", "LY9139BB6MALBZ801-2022-01-31 00:00:00-2022-02-28 00:00:00取数完成.........\n", "LY9139BB6MALBZ801-2022-02-28 00:00:00-2022-03-31 00:00:00开始取数.........\n", "Spend_time:5.189211368560791 s\n", "LY9139BB6MALBZ801-2022-02-28 00:00:00-2022-03-31 00:00:00取数完成.........\n", "LY9139BB6MALBZ801-2022-03-31 00:00:00-2022-04-30 00:00:00开始取数.........\n", "Spend_time:6.948103666305542 s\n", "LY9139BB6MALBZ801-2022-03-31 00:00:00-2022-04-30 00:00:00取数完成.........\n", "LY9139BB6MALBZ801-2022-04-30 00:00:00-2022-05-31 00:00:00开始取数.........\n", "Spend_time:6.137395143508911 s\n", "LY9139BB6MALBZ801-2022-04-30 00:00:00-2022-05-31 00:00:00取数完成.........\n", "LY9139BB6MALBZ801-2022-05-31 00:00:00-2022-06-30 00:00:00开始取数.........\n", "Spend_time:5.4389119148254395 s\n", "LY9139BB6MALBZ801-2022-05-31 00:00:00-2022-06-30 00:00:00取数完成.........\n", "LY9139BB6MALBZ801-2022-06-30 00:00:00-2022-07-31 00:00:00开始取数.........\n", "Spend_time:3.317739725112915 s\n", "LY9139BB6MALBZ801-2022-06-30 00:00:00-2022-07-31 00:00:00取数完成.........\n", "LY9139BB6MALBZ801-2022-07-31 00:00:00-2022-08-31 00:00:00开始取数.........\n", "Spend_time:5.654975414276123 s\n", "LY9139BB6MALBZ801-2022-07-31 00:00:00-2022-08-31 00:00:00取数完成.........\n", "LY9139BB6MALBZ801-2022-08-31 00:00:00-2022-09-30 00:00:00开始取数.........\n", "Spend_time:5.5772669315338135 s\n", "LY9139BB6MALBZ801-2022-08-31 00:00:00-2022-09-30 00:00:00取数完成.........\n", "LY9139BB6MALBZ801-2022-09-30 00:00:00-2022-10-31 00:00:00开始取数.........\n", "Spend_time:3.8826558589935303 s\n", "LY9139BB6MALBZ801-2022-09-30 00:00:00-2022-10-31 00:00:00取数完成.........\n", "LY9139BB6MALBZ801-2022-10-31 00:00:00-2022-11-30 00:00:00开始取数.........\n", "Traceback (most recent call last):\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/ZlwlAlgosCommon/impl/DBHbase.py\", line 58, in page_query\n", " last_rows = self.cursor.fetchall()\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/cursor.py\", line 338, in fetchall\n", " row = self.fetchone()\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/cursor.py\", line 320, in fetchone\n", " self._fetch_next_frame()\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/cursor.py\", line 160, in _fetch_next_frame\n", " frame = self._connection._client.fetch(\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/avatica/client.py\", line 595, in fetch\n", " response_data = self._apply(request)\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/avatica/client.py\", line 227, in _apply\n", " parse_error_protobuf(response_body)\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/avatica/client.py\", line 127, in parse_error_protobuf\n", " parse_and_raise_sql_error(err.error_message)\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/avatica/client.py\", line 103, in parse_and_raise_sql_error\n", " raise_sql_error(int(code), sqlstate, message)\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/avatica/client.py\", line 96, in raise_sql_error\n", " raise errors.InternalError(message, code, sqlstate)\n", "phoenixdb.errors.InternalError: ('ResultSet is closed.', 1101, 'XCL01', None)\n", "\n", "---------WARNING: HBASE 获取数据出现异常, 开始第1次重试....\n", "连接hbase数据库\n", "连接hbase数据库 成功\n", "Spend_time:7.779730796813965 s\n", "LY9139BB6MALBZ801-2022-10-31 00:00:00-2022-11-30 00:00:00取数完成.........\n", "LY9139BB6MALBZ801-2022-11-30 00:00:00-2022-12-31 00:00:00开始取数.........\n", "Spend_time:0.37944602966308594 s\n", "LY9139BB6MALBZ801-2022-11-30 00:00:00-2022-12-31 00:00:00取数完成.........\n", "LY9139BB7MALBZ323-2022-01-31 00:00:00-2022-02-28 00:00:00开始取数.........\n", "Spend_time:0.0004494190216064453 s\n", "LY9139BB7MALBZ323-2022-01-31 00:00:00-2022-02-28 00:00:00取数完成.........\n", "\"None of [Index(['time', 'sn', 'latitude', 'longitude'], dtype='object')] are in the [columns]\"\n", "LY9139BB7MALBZ323-2022-02-28 00:00:00-2022-03-31 00:00:00开始取数.........\n", "Spend_time:1.4271025657653809 s\n", "LY9139BB7MALBZ323-2022-02-28 00:00:00-2022-03-31 00:00:00取数完成.........\n", "LY9139BB7MALBZ323-2022-03-31 00:00:00-2022-04-30 00:00:00开始取数.........\n", "Spend_time:0.0008819103240966797 s\n", "LY9139BB7MALBZ323-2022-03-31 00:00:00-2022-04-30 00:00:00取数完成.........\n", "LY9139BB7MALBZ323-2022-04-30 00:00:00-2022-05-31 00:00:00开始取数.........\n", "Spend_time:0.08427619934082031 s\n", "LY9139BB7MALBZ323-2022-04-30 00:00:00-2022-05-31 00:00:00取数完成.........\n", "LY9139BB7MALBZ323-2022-05-31 00:00:00-2022-06-30 00:00:00开始取数.........\n", "Spend_time:1.0934011936187744 s\n", "LY9139BB7MALBZ323-2022-05-31 00:00:00-2022-06-30 00:00:00取数完成.........\n", "LY9139BB7MALBZ323-2022-06-30 00:00:00-2022-07-31 00:00:00开始取数.........\n", "Spend_time:2.7648355960845947 s\n", "LY9139BB7MALBZ323-2022-06-30 00:00:00-2022-07-31 00:00:00取数完成.........\n", "LY9139BB7MALBZ323-2022-07-31 00:00:00-2022-08-31 00:00:00开始取数.........\n", "Spend_time:4.54357647895813 s\n", "LY9139BB7MALBZ323-2022-07-31 00:00:00-2022-08-31 00:00:00取数完成.........\n", "LY9139BB7MALBZ323-2022-08-31 00:00:00-2022-09-30 00:00:00开始取数.........\n", "Spend_time:3.5033068656921387 s\n", "LY9139BB7MALBZ323-2022-08-31 00:00:00-2022-09-30 00:00:00取数完成.........\n", "LY9139BB7MALBZ323-2022-09-30 00:00:00-2022-10-31 00:00:00开始取数.........\n", "Spend_time:5.2729175090789795 s\n", "LY9139BB7MALBZ323-2022-09-30 00:00:00-2022-10-31 00:00:00取数完成.........\n", "LY9139BB7MALBZ323-2022-10-31 00:00:00-2022-11-30 00:00:00开始取数.........\n", "Spend_time:5.161328315734863 s\n", "LY9139BB7MALBZ323-2022-10-31 00:00:00-2022-11-30 00:00:00取数完成.........\n", "LY9139BB7MALBZ323-2022-11-30 00:00:00-2022-12-31 00:00:00开始取数.........\n", "Spend_time:0.16026091575622559 s\n", "LY9139BB7MALBZ323-2022-11-30 00:00:00-2022-12-31 00:00:00取数完成.........\n", "LY9139BB7MALBZ807-2022-01-31 00:00:00-2022-02-28 00:00:00开始取数.........\n", "Spend_time:4.992520093917847 s\n", "LY9139BB7MALBZ807-2022-01-31 00:00:00-2022-02-28 00:00:00取数完成.........\n", "LY9139BB7MALBZ807-2022-02-28 00:00:00-2022-03-31 00:00:00开始取数.........\n", "Spend_time:7.683324575424194 s\n", "LY9139BB7MALBZ807-2022-02-28 00:00:00-2022-03-31 00:00:00取数完成.........\n", "LY9139BB7MALBZ807-2022-03-31 00:00:00-2022-04-30 00:00:00开始取数.........\n", "Spend_time:7.213382720947266 s\n", "LY9139BB7MALBZ807-2022-03-31 00:00:00-2022-04-30 00:00:00取数完成.........\n", "LY9139BB7MALBZ807-2022-04-30 00:00:00-2022-05-31 00:00:00开始取数.........\n", "Spend_time:6.932296514511108 s\n", "LY9139BB7MALBZ807-2022-04-30 00:00:00-2022-05-31 00:00:00取数完成.........\n", "LY9139BB7MALBZ807-2022-05-31 00:00:00-2022-06-30 00:00:00开始取数.........\n", "Spend_time:4.065492630004883 s\n", "LY9139BB7MALBZ807-2022-05-31 00:00:00-2022-06-30 00:00:00取数完成.........\n", "LY9139BB7MALBZ807-2022-06-30 00:00:00-2022-07-31 00:00:00开始取数.........\n", "Spend_time:7.582496166229248 s\n", "LY9139BB7MALBZ807-2022-06-30 00:00:00-2022-07-31 00:00:00取数完成.........\n", "LY9139BB7MALBZ807-2022-07-31 00:00:00-2022-08-31 00:00:00开始取数.........\n", "Spend_time:3.3365509510040283 s\n", "LY9139BB7MALBZ807-2022-07-31 00:00:00-2022-08-31 00:00:00取数完成.........\n", "LY9139BB7MALBZ807-2022-08-31 00:00:00-2022-09-30 00:00:00开始取数.........\n", "Spend_time:7.897917747497559 s\n", "LY9139BB7MALBZ807-2022-08-31 00:00:00-2022-09-30 00:00:00取数完成.........\n", "LY9139BB7MALBZ807-2022-09-30 00:00:00-2022-10-31 00:00:00开始取数.........\n", "Spend_time:9.088417291641235 s\n", "LY9139BB7MALBZ807-2022-09-30 00:00:00-2022-10-31 00:00:00取数完成.........\n", "LY9139BB7MALBZ807-2022-10-31 00:00:00-2022-11-30 00:00:00开始取数.........\n", "Spend_time:6.725415468215942 s\n", "LY9139BB7MALBZ807-2022-10-31 00:00:00-2022-11-30 00:00:00取数完成.........\n", "LY9139BB7MALBZ807-2022-11-30 00:00:00-2022-12-31 00:00:00开始取数.........\n", "Spend_time:0.543785572052002 s\n", "LY9139BB7MALBZ807-2022-11-30 00:00:00-2022-12-31 00:00:00取数完成.........\n", "LY9139BB7MALBZ810-2022-01-31 00:00:00-2022-02-28 00:00:00开始取数.........\n", "Spend_time:4.509005546569824 s\n", "LY9139BB7MALBZ810-2022-01-31 00:00:00-2022-02-28 00:00:00取数完成.........\n", "LY9139BB7MALBZ810-2022-02-28 00:00:00-2022-03-31 00:00:00开始取数.........\n", "Spend_time:2.414788007736206 s\n", "LY9139BB7MALBZ810-2022-02-28 00:00:00-2022-03-31 00:00:00取数完成.........\n", "LY9139BB7MALBZ810-2022-03-31 00:00:00-2022-04-30 00:00:00开始取数.........\n", "Spend_time:3.094947576522827 s\n", "LY9139BB7MALBZ810-2022-03-31 00:00:00-2022-04-30 00:00:00取数完成.........\n", "LY9139BB7MALBZ810-2022-04-30 00:00:00-2022-05-31 00:00:00开始取数.........\n", "Spend_time:4.858871221542358 s\n", "LY9139BB7MALBZ810-2022-04-30 00:00:00-2022-05-31 00:00:00取数完成.........\n", "LY9139BB7MALBZ810-2022-05-31 00:00:00-2022-06-30 00:00:00开始取数.........\n", "Spend_time:4.934130668640137 s\n", "LY9139BB7MALBZ810-2022-05-31 00:00:00-2022-06-30 00:00:00取数完成.........\n", "LY9139BB7MALBZ810-2022-06-30 00:00:00-2022-07-31 00:00:00开始取数.........\n", "Spend_time:4.879866600036621 s\n", "LY9139BB7MALBZ810-2022-06-30 00:00:00-2022-07-31 00:00:00取数完成.........\n", "LY9139BB7MALBZ810-2022-07-31 00:00:00-2022-08-31 00:00:00开始取数.........\n", "Spend_time:3.205798387527466 s\n", "LY9139BB7MALBZ810-2022-07-31 00:00:00-2022-08-31 00:00:00取数完成.........\n", "LY9139BB7MALBZ810-2022-08-31 00:00:00-2022-09-30 00:00:00开始取数.........\n", "Spend_time:2.385364532470703 s\n", "LY9139BB7MALBZ810-2022-08-31 00:00:00-2022-09-30 00:00:00取数完成.........\n", "LY9139BB7MALBZ810-2022-09-30 00:00:00-2022-10-31 00:00:00开始取数.........\n", "Spend_time:3.6120824813842773 s\n", "LY9139BB7MALBZ810-2022-09-30 00:00:00-2022-10-31 00:00:00取数完成.........\n", "LY9139BB7MALBZ810-2022-10-31 00:00:00-2022-11-30 00:00:00开始取数.........\n", "Spend_time:6.844615936279297 s\n", "LY9139BB7MALBZ810-2022-10-31 00:00:00-2022-11-30 00:00:00取数完成.........\n", "LY9139BB7MALBZ810-2022-11-30 00:00:00-2022-12-31 00:00:00开始取数.........\n", "Spend_time:0.19522857666015625 s\n", "LY9139BB7MALBZ810-2022-11-30 00:00:00-2022-12-31 00:00:00取数完成.........\n", "LY9139BB8MALBZ329-2022-01-31 00:00:00-2022-02-28 00:00:00开始取数.........\n", "Spend_time:0.001672506332397461 s\n", "LY9139BB8MALBZ329-2022-01-31 00:00:00-2022-02-28 00:00:00取数完成.........\n", "LY9139BB8MALBZ329-2022-02-28 00:00:00-2022-03-31 00:00:00开始取数.........\n", "Spend_time:0.0004649162292480469 s\n", "LY9139BB8MALBZ329-2022-02-28 00:00:00-2022-03-31 00:00:00取数完成.........\n", "\"None of [Index(['time', 'sn', 'latitude', 'longitude'], dtype='object')] are in the [columns]\"\n", "LY9139BB8MALBZ329-2022-03-31 00:00:00-2022-04-30 00:00:00开始取数.........\n", "Spend_time:0.0004622936248779297 s\n", "LY9139BB8MALBZ329-2022-03-31 00:00:00-2022-04-30 00:00:00取数完成.........\n", "\"None of [Index(['time', 'sn', 'latitude', 'longitude'], dtype='object')] are in the [columns]\"\n", "LY9139BB8MALBZ329-2022-04-30 00:00:00-2022-05-31 00:00:00开始取数.........\n", "Spend_time:0.21876025199890137 s\n", "LY9139BB8MALBZ329-2022-04-30 00:00:00-2022-05-31 00:00:00取数完成.........\n", "LY9139BB8MALBZ329-2022-05-31 00:00:00-2022-06-30 00:00:00开始取数.........\n", "Spend_time:0.5733420848846436 s\n", "LY9139BB8MALBZ329-2022-05-31 00:00:00-2022-06-30 00:00:00取数完成.........\n", "LY9139BB8MALBZ329-2022-06-30 00:00:00-2022-07-31 00:00:00开始取数.........\n", "Spend_time:2.9879589080810547 s\n", "LY9139BB8MALBZ329-2022-06-30 00:00:00-2022-07-31 00:00:00取数完成.........\n", "LY9139BB8MALBZ329-2022-07-31 00:00:00-2022-08-31 00:00:00开始取数.........\n", "Spend_time:4.803120374679565 s\n", "LY9139BB8MALBZ329-2022-07-31 00:00:00-2022-08-31 00:00:00取数完成.........\n", "LY9139BB8MALBZ329-2022-08-31 00:00:00-2022-09-30 00:00:00开始取数.........\n", "Spend_time:6.468098878860474 s\n", "LY9139BB8MALBZ329-2022-08-31 00:00:00-2022-09-30 00:00:00取数完成.........\n", "LY9139BB8MALBZ329-2022-09-30 00:00:00-2022-10-31 00:00:00开始取数.........\n", "Spend_time:5.107086658477783 s\n", "LY9139BB8MALBZ329-2022-09-30 00:00:00-2022-10-31 00:00:00取数完成.........\n", "LY9139BB8MALBZ329-2022-10-31 00:00:00-2022-11-30 00:00:00开始取数.........\n", "Spend_time:5.656421899795532 s\n", "LY9139BB8MALBZ329-2022-10-31 00:00:00-2022-11-30 00:00:00取数完成.........\n", "LY9139BB8MALBZ329-2022-11-30 00:00:00-2022-12-31 00:00:00开始取数.........\n", "Spend_time:0.33678460121154785 s\n", "LY9139BB8MALBZ329-2022-11-30 00:00:00-2022-12-31 00:00:00取数完成.........\n", "LY9139BB8MALBZ427-2022-01-31 00:00:00-2022-02-28 00:00:00开始取数.........\n", "Spend_time:3.39614200592041 s\n", "LY9139BB8MALBZ427-2022-01-31 00:00:00-2022-02-28 00:00:00取数完成.........\n", "LY9139BB8MALBZ427-2022-02-28 00:00:00-2022-03-31 00:00:00开始取数.........\n", "Spend_time:2.6635921001434326 s\n", "LY9139BB8MALBZ427-2022-02-28 00:00:00-2022-03-31 00:00:00取数完成.........\n", "LY9139BB8MALBZ427-2022-03-31 00:00:00-2022-04-30 00:00:00开始取数.........\n", "Spend_time:3.902686357498169 s\n", "LY9139BB8MALBZ427-2022-03-31 00:00:00-2022-04-30 00:00:00取数完成.........\n", "LY9139BB8MALBZ427-2022-04-30 00:00:00-2022-05-31 00:00:00开始取数.........\n", "Spend_time:7.7824530601501465 s\n", "LY9139BB8MALBZ427-2022-04-30 00:00:00-2022-05-31 00:00:00取数完成.........\n", "LY9139BB8MALBZ427-2022-05-31 00:00:00-2022-06-30 00:00:00开始取数.........\n", "Spend_time:4.747098684310913 s\n", "LY9139BB8MALBZ427-2022-05-31 00:00:00-2022-06-30 00:00:00取数完成.........\n", "LY9139BB8MALBZ427-2022-06-30 00:00:00-2022-07-31 00:00:00开始取数.........\n", "Spend_time:4.265201091766357 s\n", "LY9139BB8MALBZ427-2022-06-30 00:00:00-2022-07-31 00:00:00取数完成.........\n", "LY9139BB8MALBZ427-2022-07-31 00:00:00-2022-08-31 00:00:00开始取数.........\n", "Spend_time:5.323606491088867 s\n", "LY9139BB8MALBZ427-2022-07-31 00:00:00-2022-08-31 00:00:00取数完成.........\n", "LY9139BB8MALBZ427-2022-08-31 00:00:00-2022-09-30 00:00:00开始取数.........\n", "Spend_time:3.5992326736450195 s\n", "LY9139BB8MALBZ427-2022-08-31 00:00:00-2022-09-30 00:00:00取数完成.........\n", "LY9139BB8MALBZ427-2022-09-30 00:00:00-2022-10-31 00:00:00开始取数.........\n", "Spend_time:2.9892053604125977 s\n", "LY9139BB8MALBZ427-2022-09-30 00:00:00-2022-10-31 00:00:00取数完成.........\n", "LY9139BB8MALBZ427-2022-10-31 00:00:00-2022-11-30 00:00:00开始取数.........\n", "Spend_time:3.08890438079834 s\n", "LY9139BB8MALBZ427-2022-10-31 00:00:00-2022-11-30 00:00:00取数完成.........\n", "LY9139BB8MALBZ427-2022-11-30 00:00:00-2022-12-31 00:00:00开始取数.........\n", "Spend_time:0.18338656425476074 s\n", "LY9139BB8MALBZ427-2022-11-30 00:00:00-2022-12-31 00:00:00取数完成.........\n", "LY9139BB8MALBZ430-2022-01-31 00:00:00-2022-02-28 00:00:00开始取数.........\n", "Spend_time:3.184568405151367 s\n", "LY9139BB8MALBZ430-2022-01-31 00:00:00-2022-02-28 00:00:00取数完成.........\n", "LY9139BB8MALBZ430-2022-02-28 00:00:00-2022-03-31 00:00:00开始取数.........\n", "Spend_time:6.100152492523193 s\n", "LY9139BB8MALBZ430-2022-02-28 00:00:00-2022-03-31 00:00:00取数完成.........\n", "LY9139BB8MALBZ430-2022-03-31 00:00:00-2022-04-30 00:00:00开始取数.........\n", "Spend_time:4.484451770782471 s\n", "LY9139BB8MALBZ430-2022-03-31 00:00:00-2022-04-30 00:00:00取数完成.........\n", "LY9139BB8MALBZ430-2022-04-30 00:00:00-2022-05-31 00:00:00开始取数.........\n", "Spend_time:3.9896366596221924 s\n", "LY9139BB8MALBZ430-2022-04-30 00:00:00-2022-05-31 00:00:00取数完成.........\n", "LY9139BB8MALBZ430-2022-05-31 00:00:00-2022-06-30 00:00:00开始取数.........\n", "Spend_time:4.6030802726745605 s\n", "LY9139BB8MALBZ430-2022-05-31 00:00:00-2022-06-30 00:00:00取数完成.........\n", "LY9139BB8MALBZ430-2022-06-30 00:00:00-2022-07-31 00:00:00开始取数.........\n", "Spend_time:5.583696603775024 s\n", "LY9139BB8MALBZ430-2022-06-30 00:00:00-2022-07-31 00:00:00取数完成.........\n", "LY9139BB8MALBZ430-2022-07-31 00:00:00-2022-08-31 00:00:00开始取数.........\n", "Spend_time:5.956709861755371 s\n", "LY9139BB8MALBZ430-2022-07-31 00:00:00-2022-08-31 00:00:00取数完成.........\n", "LY9139BB8MALBZ430-2022-08-31 00:00:00-2022-09-30 00:00:00开始取数.........\n", "Spend_time:6.742547512054443 s\n", "LY9139BB8MALBZ430-2022-08-31 00:00:00-2022-09-30 00:00:00取数完成.........\n", "LY9139BB8MALBZ430-2022-09-30 00:00:00-2022-10-31 00:00:00开始取数.........\n", "Spend_time:5.215718984603882 s\n", "LY9139BB8MALBZ430-2022-09-30 00:00:00-2022-10-31 00:00:00取数完成.........\n", "LY9139BB8MALBZ430-2022-10-31 00:00:00-2022-11-30 00:00:00开始取数.........\n", "Spend_time:5.0875818729400635 s\n", "LY9139BB8MALBZ430-2022-10-31 00:00:00-2022-11-30 00:00:00取数完成.........\n", "LY9139BB8MALBZ430-2022-11-30 00:00:00-2022-12-31 00:00:00开始取数.........\n", "Spend_time:0.44518303871154785 s\n", "LY9139BB8MALBZ430-2022-11-30 00:00:00-2022-12-31 00:00:00取数完成.........\n", "LY9139BB8MALBZ797-2022-01-31 00:00:00-2022-02-28 00:00:00开始取数.........\n", "Spend_time:5.803468942642212 s\n", "LY9139BB8MALBZ797-2022-01-31 00:00:00-2022-02-28 00:00:00取数完成.........\n", "LY9139BB8MALBZ797-2022-02-28 00:00:00-2022-03-31 00:00:00开始取数.........\n", "Spend_time:3.7466537952423096 s\n", "LY9139BB8MALBZ797-2022-02-28 00:00:00-2022-03-31 00:00:00取数完成.........\n", "LY9139BB8MALBZ797-2022-03-31 00:00:00-2022-04-30 00:00:00开始取数.........\n", "Spend_time:4.7333080768585205 s\n", "LY9139BB8MALBZ797-2022-03-31 00:00:00-2022-04-30 00:00:00取数完成.........\n", "LY9139BB8MALBZ797-2022-04-30 00:00:00-2022-05-31 00:00:00开始取数.........\n", "Traceback (most recent call last):\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/ZlwlAlgosCommon/impl/DBHbase.py\", line 58, in page_query\n", " last_rows = self.cursor.fetchall()\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/cursor.py\", line 338, in fetchall\n", " row = self.fetchone()\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/cursor.py\", line 320, in fetchone\n", " self._fetch_next_frame()\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/cursor.py\", line 160, in _fetch_next_frame\n", " frame = self._connection._client.fetch(\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/avatica/client.py\", line 595, in fetch\n", " response_data = self._apply(request)\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/avatica/client.py\", line 227, in _apply\n", " parse_error_protobuf(response_body)\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/avatica/client.py\", line 127, in parse_error_protobuf\n", " parse_and_raise_sql_error(err.error_message)\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/avatica/client.py\", line 103, in parse_and_raise_sql_error\n", " raise_sql_error(int(code), sqlstate, message)\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/avatica/client.py\", line 96, in raise_sql_error\n", " raise errors.InternalError(message, code, sqlstate)\n", "phoenixdb.errors.InternalError: ('ResultSet is closed.', 1101, 'XCL01', None)\n", "\n", "---------WARNING: HBASE 获取数据出现异常, 开始第1次重试....\n", "连接hbase数据库\n", "连接hbase数据库 成功\n", "Spend_time:4.896725177764893 s\n", "LY9139BB8MALBZ797-2022-04-30 00:00:00-2022-05-31 00:00:00取数完成.........\n", "LY9139BB8MALBZ797-2022-05-31 00:00:00-2022-06-30 00:00:00开始取数.........\n", "Spend_time:3.945237398147583 s\n", "LY9139BB8MALBZ797-2022-05-31 00:00:00-2022-06-30 00:00:00取数完成.........\n", "LY9139BB8MALBZ797-2022-06-30 00:00:00-2022-07-31 00:00:00开始取数.........\n", "Spend_time:4.790555238723755 s\n", "LY9139BB8MALBZ797-2022-06-30 00:00:00-2022-07-31 00:00:00取数完成.........\n", "LY9139BB8MALBZ797-2022-07-31 00:00:00-2022-08-31 00:00:00开始取数.........\n", "Spend_time:3.739301919937134 s\n", "LY9139BB8MALBZ797-2022-07-31 00:00:00-2022-08-31 00:00:00取数完成.........\n", "LY9139BB8MALBZ797-2022-08-31 00:00:00-2022-09-30 00:00:00开始取数.........\n", "Spend_time:4.908915042877197 s\n", "LY9139BB8MALBZ797-2022-08-31 00:00:00-2022-09-30 00:00:00取数完成.........\n", "LY9139BB8MALBZ797-2022-09-30 00:00:00-2022-10-31 00:00:00开始取数.........\n", "Spend_time:3.6355834007263184 s\n", "LY9139BB8MALBZ797-2022-09-30 00:00:00-2022-10-31 00:00:00取数完成.........\n", "LY9139BB8MALBZ797-2022-10-31 00:00:00-2022-11-30 00:00:00开始取数.........\n", "Spend_time:4.448142051696777 s\n", "LY9139BB8MALBZ797-2022-10-31 00:00:00-2022-11-30 00:00:00取数完成.........\n", "LY9139BB8MALBZ797-2022-11-30 00:00:00-2022-12-31 00:00:00开始取数.........\n", "Spend_time:0.18762469291687012 s\n", "LY9139BB8MALBZ797-2022-11-30 00:00:00-2022-12-31 00:00:00取数完成.........\n", "LY9139BB8MALBZ802-2022-01-31 00:00:00-2022-02-28 00:00:00开始取数.........\n", "Spend_time:2.2298614978790283 s\n", "LY9139BB8MALBZ802-2022-01-31 00:00:00-2022-02-28 00:00:00取数完成.........\n", "LY9139BB8MALBZ802-2022-02-28 00:00:00-2022-03-31 00:00:00开始取数.........\n", "Spend_time:4.842843294143677 s\n", "LY9139BB8MALBZ802-2022-02-28 00:00:00-2022-03-31 00:00:00取数完成.........\n", "LY9139BB8MALBZ802-2022-03-31 00:00:00-2022-04-30 00:00:00开始取数.........\n", "Spend_time:6.839865446090698 s\n", "LY9139BB8MALBZ802-2022-03-31 00:00:00-2022-04-30 00:00:00取数完成.........\n", "LY9139BB8MALBZ802-2022-04-30 00:00:00-2022-05-31 00:00:00开始取数.........\n", "Spend_time:7.87152361869812 s\n", "LY9139BB8MALBZ802-2022-04-30 00:00:00-2022-05-31 00:00:00取数完成.........\n", "LY9139BB8MALBZ802-2022-05-31 00:00:00-2022-06-30 00:00:00开始取数.........\n", "Spend_time:3.550661087036133 s\n", "LY9139BB8MALBZ802-2022-05-31 00:00:00-2022-06-30 00:00:00取数完成.........\n", "LY9139BB8MALBZ802-2022-06-30 00:00:00-2022-07-31 00:00:00开始取数.........\n", "Spend_time:4.410991668701172 s\n", "LY9139BB8MALBZ802-2022-06-30 00:00:00-2022-07-31 00:00:00取数完成.........\n", "LY9139BB8MALBZ802-2022-07-31 00:00:00-2022-08-31 00:00:00开始取数.........\n", "Spend_time:4.4127583503723145 s\n", "LY9139BB8MALBZ802-2022-07-31 00:00:00-2022-08-31 00:00:00取数完成.........\n", "LY9139BB8MALBZ802-2022-08-31 00:00:00-2022-09-30 00:00:00开始取数.........\n", "Spend_time:4.567301988601685 s\n", "LY9139BB8MALBZ802-2022-08-31 00:00:00-2022-09-30 00:00:00取数完成.........\n", "LY9139BB8MALBZ802-2022-09-30 00:00:00-2022-10-31 00:00:00开始取数.........\n", "Spend_time:7.619601488113403 s\n", "LY9139BB8MALBZ802-2022-09-30 00:00:00-2022-10-31 00:00:00取数完成.........\n", "LY9139BB8MALBZ802-2022-10-31 00:00:00-2022-11-30 00:00:00开始取数.........\n", "Spend_time:8.433341026306152 s\n", "LY9139BB8MALBZ802-2022-10-31 00:00:00-2022-11-30 00:00:00取数完成.........\n", "LY9139BB8MALBZ802-2022-11-30 00:00:00-2022-12-31 00:00:00开始取数.........\n", "Spend_time:0.22344684600830078 s\n", "LY9139BB8MALBZ802-2022-11-30 00:00:00-2022-12-31 00:00:00取数完成.........\n", "LY9139BB9MALBZ310-2022-01-31 00:00:00-2022-02-28 00:00:00开始取数.........\n", "Spend_time:0.028395414352416992 s\n", "LY9139BB9MALBZ310-2022-01-31 00:00:00-2022-02-28 00:00:00取数完成.........\n", "LY9139BB9MALBZ310-2022-02-28 00:00:00-2022-03-31 00:00:00开始取数.........\n", "Spend_time:0.8892836570739746 s\n", "LY9139BB9MALBZ310-2022-02-28 00:00:00-2022-03-31 00:00:00取数完成.........\n", "LY9139BB9MALBZ310-2022-03-31 00:00:00-2022-04-30 00:00:00开始取数.........\n", "Spend_time:0.368072509765625 s\n", "LY9139BB9MALBZ310-2022-03-31 00:00:00-2022-04-30 00:00:00取数完成.........\n", "LY9139BB9MALBZ310-2022-04-30 00:00:00-2022-05-31 00:00:00开始取数.........\n", "Spend_time:0.5409393310546875 s\n", "LY9139BB9MALBZ310-2022-04-30 00:00:00-2022-05-31 00:00:00取数完成.........\n", "LY9139BB9MALBZ310-2022-05-31 00:00:00-2022-06-30 00:00:00开始取数.........\n", "Spend_time:2.142942428588867 s\n", "LY9139BB9MALBZ310-2022-05-31 00:00:00-2022-06-30 00:00:00取数完成.........\n", "LY9139BB9MALBZ310-2022-06-30 00:00:00-2022-07-31 00:00:00开始取数.........\n", "Spend_time:5.948036193847656 s\n", "LY9139BB9MALBZ310-2022-06-30 00:00:00-2022-07-31 00:00:00取数完成.........\n", "LY9139BB9MALBZ310-2022-07-31 00:00:00-2022-08-31 00:00:00开始取数.........\n", "Spend_time:5.186664819717407 s\n", "LY9139BB9MALBZ310-2022-07-31 00:00:00-2022-08-31 00:00:00取数完成.........\n", "LY9139BB9MALBZ310-2022-08-31 00:00:00-2022-09-30 00:00:00开始取数.........\n", "Spend_time:2.902925729751587 s\n", "LY9139BB9MALBZ310-2022-08-31 00:00:00-2022-09-30 00:00:00取数完成.........\n", "LY9139BB9MALBZ310-2022-09-30 00:00:00-2022-10-31 00:00:00开始取数.........\n", "Traceback (most recent call last):\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/ZlwlAlgosCommon/impl/DBHbase.py\", line 58, in page_query\n", " last_rows = self.cursor.fetchall()\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/cursor.py\", line 338, in fetchall\n", " row = self.fetchone()\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/cursor.py\", line 320, in fetchone\n", " self._fetch_next_frame()\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/cursor.py\", line 160, in _fetch_next_frame\n", " frame = self._connection._client.fetch(\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/avatica/client.py\", line 595, in fetch\n", " response_data = self._apply(request)\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/avatica/client.py\", line 227, in _apply\n", " parse_error_protobuf(response_body)\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/avatica/client.py\", line 127, in parse_error_protobuf\n", " parse_and_raise_sql_error(err.error_message)\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/avatica/client.py\", line 103, in parse_and_raise_sql_error\n", " raise_sql_error(int(code), sqlstate, message)\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/avatica/client.py\", line 96, in raise_sql_error\n", " raise errors.InternalError(message, code, sqlstate)\n", "phoenixdb.errors.InternalError: ('ResultSet is closed.', 1101, 'XCL01', None)\n", "\n", "---------WARNING: HBASE 获取数据出现异常, 开始第1次重试....\n", "连接hbase数据库\n", "连接hbase数据库 成功\n", "Spend_time:4.83221697807312 s\n", "LY9139BB9MALBZ310-2022-09-30 00:00:00-2022-10-31 00:00:00取数完成.........\n", "LY9139BB9MALBZ310-2022-10-31 00:00:00-2022-11-30 00:00:00开始取数.........\n", "Spend_time:6.658235311508179 s\n", "LY9139BB9MALBZ310-2022-10-31 00:00:00-2022-11-30 00:00:00取数完成.........\n", "LY9139BB9MALBZ310-2022-11-30 00:00:00-2022-12-31 00:00:00开始取数.........\n", "Spend_time:0.26737189292907715 s\n", "LY9139BB9MALBZ310-2022-11-30 00:00:00-2022-12-31 00:00:00取数完成.........\n", "LY9139BB9MALBZ338-2022-01-31 00:00:00-2022-02-28 00:00:00开始取数.........\n", "Spend_time:0.9490933418273926 s\n", "LY9139BB9MALBZ338-2022-01-31 00:00:00-2022-02-28 00:00:00取数完成.........\n", "LY9139BB9MALBZ338-2022-02-28 00:00:00-2022-03-31 00:00:00开始取数.........\n", "Spend_time:4.967741250991821 s\n", "LY9139BB9MALBZ338-2022-02-28 00:00:00-2022-03-31 00:00:00取数完成.........\n", "LY9139BB9MALBZ338-2022-03-31 00:00:00-2022-04-30 00:00:00开始取数.........\n", "Spend_time:2.425652027130127 s\n", "LY9139BB9MALBZ338-2022-03-31 00:00:00-2022-04-30 00:00:00取数完成.........\n", "LY9139BB9MALBZ338-2022-04-30 00:00:00-2022-05-31 00:00:00开始取数.........\n", "Spend_time:2.249370813369751 s\n", "LY9139BB9MALBZ338-2022-04-30 00:00:00-2022-05-31 00:00:00取数完成.........\n", "LY9139BB9MALBZ338-2022-05-31 00:00:00-2022-06-30 00:00:00开始取数.........\n", "Spend_time:4.527754545211792 s\n", "LY9139BB9MALBZ338-2022-05-31 00:00:00-2022-06-30 00:00:00取数完成.........\n", "LY9139BB9MALBZ338-2022-06-30 00:00:00-2022-07-31 00:00:00开始取数.........\n", "Spend_time:5.567468166351318 s\n", "LY9139BB9MALBZ338-2022-06-30 00:00:00-2022-07-31 00:00:00取数完成.........\n", "LY9139BB9MALBZ338-2022-07-31 00:00:00-2022-08-31 00:00:00开始取数.........\n", "Spend_time:3.912172555923462 s\n", "LY9139BB9MALBZ338-2022-07-31 00:00:00-2022-08-31 00:00:00取数完成.........\n", "LY9139BB9MALBZ338-2022-08-31 00:00:00-2022-09-30 00:00:00开始取数.........\n", "Spend_time:4.635012626647949 s\n", "LY9139BB9MALBZ338-2022-08-31 00:00:00-2022-09-30 00:00:00取数完成.........\n", "LY9139BB9MALBZ338-2022-09-30 00:00:00-2022-10-31 00:00:00开始取数.........\n", "Spend_time:6.240872621536255 s\n", "LY9139BB9MALBZ338-2022-09-30 00:00:00-2022-10-31 00:00:00取数完成.........\n", "LY9139BB9MALBZ338-2022-10-31 00:00:00-2022-11-30 00:00:00开始取数.........\n", "Spend_time:6.346734046936035 s\n", "LY9139BB9MALBZ338-2022-10-31 00:00:00-2022-11-30 00:00:00取数完成.........\n", "LY9139BB9MALBZ338-2022-11-30 00:00:00-2022-12-31 00:00:00开始取数.........\n", "Spend_time:0.6293916702270508 s\n", "LY9139BB9MALBZ338-2022-11-30 00:00:00-2022-12-31 00:00:00取数完成.........\n", "LY9139BB9MALBZ808-2022-01-31 00:00:00-2022-02-28 00:00:00开始取数.........\n", "Spend_time:2.9559121131896973 s\n", "LY9139BB9MALBZ808-2022-01-31 00:00:00-2022-02-28 00:00:00取数完成.........\n", "LY9139BB9MALBZ808-2022-02-28 00:00:00-2022-03-31 00:00:00开始取数.........\n", "Spend_time:4.8114142417907715 s\n", "LY9139BB9MALBZ808-2022-02-28 00:00:00-2022-03-31 00:00:00取数完成.........\n", "LY9139BB9MALBZ808-2022-03-31 00:00:00-2022-04-30 00:00:00开始取数.........\n", "Spend_time:4.063990592956543 s\n", "LY9139BB9MALBZ808-2022-03-31 00:00:00-2022-04-30 00:00:00取数完成.........\n", "LY9139BB9MALBZ808-2022-04-30 00:00:00-2022-05-31 00:00:00开始取数.........\n", "Spend_time:7.473736524581909 s\n", "LY9139BB9MALBZ808-2022-04-30 00:00:00-2022-05-31 00:00:00取数完成.........\n", "LY9139BB9MALBZ808-2022-05-31 00:00:00-2022-06-30 00:00:00开始取数.........\n", "Spend_time:3.3662972450256348 s\n", "LY9139BB9MALBZ808-2022-05-31 00:00:00-2022-06-30 00:00:00取数完成.........\n", "LY9139BB9MALBZ808-2022-06-30 00:00:00-2022-07-31 00:00:00开始取数.........\n", "Spend_time:6.388933181762695 s\n", "LY9139BB9MALBZ808-2022-06-30 00:00:00-2022-07-31 00:00:00取数完成.........\n", "LY9139BB9MALBZ808-2022-07-31 00:00:00-2022-08-31 00:00:00开始取数.........\n", "Spend_time:3.655575752258301 s\n", "LY9139BB9MALBZ808-2022-07-31 00:00:00-2022-08-31 00:00:00取数完成.........\n", "LY9139BB9MALBZ808-2022-08-31 00:00:00-2022-09-30 00:00:00开始取数.........\n", "Spend_time:5.666813135147095 s\n", "LY9139BB9MALBZ808-2022-08-31 00:00:00-2022-09-30 00:00:00取数完成.........\n", "LY9139BB9MALBZ808-2022-09-30 00:00:00-2022-10-31 00:00:00开始取数.........\n", "Spend_time:7.403499126434326 s\n", "LY9139BB9MALBZ808-2022-09-30 00:00:00-2022-10-31 00:00:00取数完成.........\n", "LY9139BB9MALBZ808-2022-10-31 00:00:00-2022-11-30 00:00:00开始取数.........\n", "Traceback (most recent call last):\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/ZlwlAlgosCommon/impl/DBHbase.py\", line 58, in page_query\n", " last_rows = self.cursor.fetchall()\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/cursor.py\", line 338, in fetchall\n", " row = self.fetchone()\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/cursor.py\", line 320, in fetchone\n", " self._fetch_next_frame()\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/cursor.py\", line 160, in _fetch_next_frame\n", " frame = self._connection._client.fetch(\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/avatica/client.py\", line 595, in fetch\n", " response_data = self._apply(request)\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/avatica/client.py\", line 227, in _apply\n", " parse_error_protobuf(response_body)\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/avatica/client.py\", line 127, in parse_error_protobuf\n", " parse_and_raise_sql_error(err.error_message)\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/avatica/client.py\", line 103, in parse_and_raise_sql_error\n", " raise_sql_error(int(code), sqlstate, message)\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/avatica/client.py\", line 96, in raise_sql_error\n", " raise errors.InternalError(message, code, sqlstate)\n", "phoenixdb.errors.InternalError: ('ResultSet is closed.', 1101, 'XCL01', None)\n", "\n", "---------WARNING: HBASE 获取数据出现异常, 开始第1次重试....\n", "连接hbase数据库\n", "连接hbase数据库 成功\n", "Spend_time:7.378555774688721 s\n", "LY9139BB9MALBZ808-2022-10-31 00:00:00-2022-11-30 00:00:00取数完成.........\n", "LY9139BB9MALBZ808-2022-11-30 00:00:00-2022-12-31 00:00:00开始取数.........\n", "Spend_time:0.3153800964355469 s\n", "LY9139BB9MALBZ808-2022-11-30 00:00:00-2022-12-31 00:00:00取数完成.........\n", "LY9139BB9MALBZ811-2022-01-31 00:00:00-2022-02-28 00:00:00开始取数.........\n", "Spend_time:1.986053228378296 s\n", "LY9139BB9MALBZ811-2022-01-31 00:00:00-2022-02-28 00:00:00取数完成.........\n", "LY9139BB9MALBZ811-2022-02-28 00:00:00-2022-03-31 00:00:00开始取数.........\n", "Spend_time:3.034649610519409 s\n", "LY9139BB9MALBZ811-2022-02-28 00:00:00-2022-03-31 00:00:00取数完成.........\n", "LY9139BB9MALBZ811-2022-03-31 00:00:00-2022-04-30 00:00:00开始取数.........\n", "Spend_time:5.576968431472778 s\n", "LY9139BB9MALBZ811-2022-03-31 00:00:00-2022-04-30 00:00:00取数完成.........\n", "LY9139BB9MALBZ811-2022-04-30 00:00:00-2022-05-31 00:00:00开始取数.........\n", "Spend_time:6.000893592834473 s\n", "LY9139BB9MALBZ811-2022-04-30 00:00:00-2022-05-31 00:00:00取数完成.........\n", "LY9139BB9MALBZ811-2022-05-31 00:00:00-2022-06-30 00:00:00开始取数.........\n", "Spend_time:4.012973308563232 s\n", "LY9139BB9MALBZ811-2022-05-31 00:00:00-2022-06-30 00:00:00取数完成.........\n", "LY9139BB9MALBZ811-2022-06-30 00:00:00-2022-07-31 00:00:00开始取数.........\n", "Spend_time:4.912169456481934 s\n", "LY9139BB9MALBZ811-2022-06-30 00:00:00-2022-07-31 00:00:00取数完成.........\n", "LY9139BB9MALBZ811-2022-07-31 00:00:00-2022-08-31 00:00:00开始取数.........\n", "Spend_time:5.132508993148804 s\n", "LY9139BB9MALBZ811-2022-07-31 00:00:00-2022-08-31 00:00:00取数完成.........\n", "LY9139BB9MALBZ811-2022-08-31 00:00:00-2022-09-30 00:00:00开始取数.........\n", "Spend_time:5.759232759475708 s\n", "LY9139BB9MALBZ811-2022-08-31 00:00:00-2022-09-30 00:00:00取数完成.........\n", "LY9139BB9MALBZ811-2022-09-30 00:00:00-2022-10-31 00:00:00开始取数.........\n", "Spend_time:5.2627599239349365 s\n", "LY9139BB9MALBZ811-2022-09-30 00:00:00-2022-10-31 00:00:00取数完成.........\n", "LY9139BB9MALBZ811-2022-10-31 00:00:00-2022-11-30 00:00:00开始取数.........\n", "Spend_time:4.583038330078125 s\n", "LY9139BB9MALBZ811-2022-10-31 00:00:00-2022-11-30 00:00:00取数完成.........\n", "LY9139BB9MALBZ811-2022-11-30 00:00:00-2022-12-31 00:00:00开始取数.........\n", "Spend_time:0.304548978805542 s\n", "LY9139BB9MALBZ811-2022-11-30 00:00:00-2022-12-31 00:00:00取数完成.........\n", "LY9139BBXMALBZ428-2022-01-31 00:00:00-2022-02-28 00:00:00开始取数.........\n", "Spend_time:1.5637376308441162 s\n", "LY9139BBXMALBZ428-2022-01-31 00:00:00-2022-02-28 00:00:00取数完成.........\n", "LY9139BBXMALBZ428-2022-02-28 00:00:00-2022-03-31 00:00:00开始取数.........\n", "Spend_time:5.077637434005737 s\n", "LY9139BBXMALBZ428-2022-02-28 00:00:00-2022-03-31 00:00:00取数完成.........\n", "LY9139BBXMALBZ428-2022-03-31 00:00:00-2022-04-30 00:00:00开始取数.........\n", "Spend_time:6.03929591178894 s\n", "LY9139BBXMALBZ428-2022-03-31 00:00:00-2022-04-30 00:00:00取数完成.........\n", "LY9139BBXMALBZ428-2022-04-30 00:00:00-2022-05-31 00:00:00开始取数.........\n", "Spend_time:4.0048987865448 s\n", "LY9139BBXMALBZ428-2022-04-30 00:00:00-2022-05-31 00:00:00取数完成.........\n", "LY9139BBXMALBZ428-2022-05-31 00:00:00-2022-06-30 00:00:00开始取数.........\n", "Spend_time:3.2811379432678223 s\n", "LY9139BBXMALBZ428-2022-05-31 00:00:00-2022-06-30 00:00:00取数完成.........\n", "LY9139BBXMALBZ428-2022-06-30 00:00:00-2022-07-31 00:00:00开始取数.........\n", "Spend_time:4.335269451141357 s\n", "LY9139BBXMALBZ428-2022-06-30 00:00:00-2022-07-31 00:00:00取数完成.........\n", "LY9139BBXMALBZ428-2022-07-31 00:00:00-2022-08-31 00:00:00开始取数.........\n", "Spend_time:2.637617349624634 s\n", "LY9139BBXMALBZ428-2022-07-31 00:00:00-2022-08-31 00:00:00取数完成.........\n", "LY9139BBXMALBZ428-2022-08-31 00:00:00-2022-09-30 00:00:00开始取数.........\n", "Spend_time:3.1481575965881348 s\n", "LY9139BBXMALBZ428-2022-08-31 00:00:00-2022-09-30 00:00:00取数完成.........\n", "LY9139BBXMALBZ428-2022-09-30 00:00:00-2022-10-31 00:00:00开始取数.........\n", "Spend_time:5.3331732749938965 s\n", "LY9139BBXMALBZ428-2022-09-30 00:00:00-2022-10-31 00:00:00取数完成.........\n", "LY9139BBXMALBZ428-2022-10-31 00:00:00-2022-11-30 00:00:00开始取数.........\n", "Spend_time:4.065679311752319 s\n", "LY9139BBXMALBZ428-2022-10-31 00:00:00-2022-11-30 00:00:00取数完成.........\n", "LY9139BBXMALBZ428-2022-11-30 00:00:00-2022-12-31 00:00:00开始取数.........\n", "Spend_time:0.2553997039794922 s\n", "LY9139BBXMALBZ428-2022-11-30 00:00:00-2022-12-31 00:00:00取数完成.........\n", "LY9139BBXMALBZ431-2022-01-31 00:00:00-2022-02-28 00:00:00开始取数.........\n", "Spend_time:2.5898141860961914 s\n", "LY9139BBXMALBZ431-2022-01-31 00:00:00-2022-02-28 00:00:00取数完成.........\n", "LY9139BBXMALBZ431-2022-02-28 00:00:00-2022-03-31 00:00:00开始取数.........\n", "Spend_time:3.236405372619629 s\n", "LY9139BBXMALBZ431-2022-02-28 00:00:00-2022-03-31 00:00:00取数完成.........\n", "LY9139BBXMALBZ431-2022-03-31 00:00:00-2022-04-30 00:00:00开始取数.........\n", "Spend_time:3.0277388095855713 s\n", "LY9139BBXMALBZ431-2022-03-31 00:00:00-2022-04-30 00:00:00取数完成.........\n", "LY9139BBXMALBZ431-2022-04-30 00:00:00-2022-05-31 00:00:00开始取数.........\n", "Traceback (most recent call last):\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/ZlwlAlgosCommon/impl/DBHbase.py\", line 58, in page_query\n", " last_rows = self.cursor.fetchall()\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/cursor.py\", line 338, in fetchall\n", " row = self.fetchone()\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/cursor.py\", line 320, in fetchone\n", " self._fetch_next_frame()\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/cursor.py\", line 160, in _fetch_next_frame\n", " frame = self._connection._client.fetch(\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/avatica/client.py\", line 595, in fetch\n", " response_data = self._apply(request)\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/avatica/client.py\", line 227, in _apply\n", " parse_error_protobuf(response_body)\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/avatica/client.py\", line 127, in parse_error_protobuf\n", " parse_and_raise_sql_error(err.error_message)\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/avatica/client.py\", line 103, in parse_and_raise_sql_error\n", " raise_sql_error(int(code), sqlstate, message)\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/avatica/client.py\", line 96, in raise_sql_error\n", " raise errors.InternalError(message, code, sqlstate)\n", "phoenixdb.errors.InternalError: ('ResultSet is closed.', 1101, 'XCL01', None)\n", "\n", "---------WARNING: HBASE 获取数据出现异常, 开始第1次重试....\n", "连接hbase数据库\n", "连接hbase数据库 成功\n", "Spend_time:7.044196605682373 s\n", "LY9139BBXMALBZ431-2022-04-30 00:00:00-2022-05-31 00:00:00取数完成.........\n", "LY9139BBXMALBZ431-2022-05-31 00:00:00-2022-06-30 00:00:00开始取数.........\n", "Spend_time:5.858002662658691 s\n", "LY9139BBXMALBZ431-2022-05-31 00:00:00-2022-06-30 00:00:00取数完成.........\n", "LY9139BBXMALBZ431-2022-06-30 00:00:00-2022-07-31 00:00:00开始取数.........\n", "Spend_time:5.63367486000061 s\n", "LY9139BBXMALBZ431-2022-06-30 00:00:00-2022-07-31 00:00:00取数完成.........\n", "LY9139BBXMALBZ431-2022-07-31 00:00:00-2022-08-31 00:00:00开始取数.........\n", "Spend_time:4.987473487854004 s\n", "LY9139BBXMALBZ431-2022-07-31 00:00:00-2022-08-31 00:00:00取数完成.........\n", "LY9139BBXMALBZ431-2022-08-31 00:00:00-2022-09-30 00:00:00开始取数.........\n", "Spend_time:5.453949689865112 s\n", "LY9139BBXMALBZ431-2022-08-31 00:00:00-2022-09-30 00:00:00取数完成.........\n", "LY9139BBXMALBZ431-2022-09-30 00:00:00-2022-10-31 00:00:00开始取数.........\n", "Spend_time:3.824352502822876 s\n", "LY9139BBXMALBZ431-2022-09-30 00:00:00-2022-10-31 00:00:00取数完成.........\n", "LY9139BBXMALBZ431-2022-10-31 00:00:00-2022-11-30 00:00:00开始取数.........\n", "Spend_time:3.458681583404541 s\n", "LY9139BBXMALBZ431-2022-10-31 00:00:00-2022-11-30 00:00:00取数完成.........\n", "LY9139BBXMALBZ431-2022-11-30 00:00:00-2022-12-31 00:00:00开始取数.........\n", "Spend_time:0.4334440231323242 s\n", "LY9139BBXMALBZ431-2022-11-30 00:00:00-2022-12-31 00:00:00取数完成.........\n", "LY9139BBXMALBZ798-2022-01-31 00:00:00-2022-02-28 00:00:00开始取数.........\n", "Spend_time:2.522413969039917 s\n", "LY9139BBXMALBZ798-2022-01-31 00:00:00-2022-02-28 00:00:00取数完成.........\n", "LY9139BBXMALBZ798-2022-02-28 00:00:00-2022-03-31 00:00:00开始取数.........\n", "Spend_time:3.741563081741333 s\n", "LY9139BBXMALBZ798-2022-02-28 00:00:00-2022-03-31 00:00:00取数完成.........\n", "LY9139BBXMALBZ798-2022-03-31 00:00:00-2022-04-30 00:00:00开始取数.........\n", "Spend_time:3.2591593265533447 s\n", "LY9139BBXMALBZ798-2022-03-31 00:00:00-2022-04-30 00:00:00取数完成.........\n", "LY9139BBXMALBZ798-2022-04-30 00:00:00-2022-05-31 00:00:00开始取数.........\n", "Spend_time:3.7757608890533447 s\n", "LY9139BBXMALBZ798-2022-04-30 00:00:00-2022-05-31 00:00:00取数完成.........\n", "LY9139BBXMALBZ798-2022-05-31 00:00:00-2022-06-30 00:00:00开始取数.........\n", "Spend_time:5.373013257980347 s\n", "LY9139BBXMALBZ798-2022-05-31 00:00:00-2022-06-30 00:00:00取数完成.........\n", "LY9139BBXMALBZ798-2022-06-30 00:00:00-2022-07-31 00:00:00开始取数.........\n", "Spend_time:2.9792964458465576 s\n", "LY9139BBXMALBZ798-2022-06-30 00:00:00-2022-07-31 00:00:00取数完成.........\n", "LY9139BBXMALBZ798-2022-07-31 00:00:00-2022-08-31 00:00:00开始取数.........\n", "Spend_time:3.1879971027374268 s\n", "LY9139BBXMALBZ798-2022-07-31 00:00:00-2022-08-31 00:00:00取数完成.........\n", "LY9139BBXMALBZ798-2022-08-31 00:00:00-2022-09-30 00:00:00开始取数.........\n", "Spend_time:2.895021438598633 s\n", "LY9139BBXMALBZ798-2022-08-31 00:00:00-2022-09-30 00:00:00取数完成.........\n", "LY9139BBXMALBZ798-2022-09-30 00:00:00-2022-10-31 00:00:00开始取数.........\n", "Spend_time:5.939713716506958 s\n", "LY9139BBXMALBZ798-2022-09-30 00:00:00-2022-10-31 00:00:00取数完成.........\n", "LY9139BBXMALBZ798-2022-10-31 00:00:00-2022-11-30 00:00:00开始取数.........\n", "Spend_time:4.295729875564575 s\n", "LY9139BBXMALBZ798-2022-10-31 00:00:00-2022-11-30 00:00:00取数完成.........\n", "LY9139BBXMALBZ798-2022-11-30 00:00:00-2022-12-31 00:00:00开始取数.........\n", "Spend_time:0.09798693656921387 s\n", "LY9139BBXMALBZ798-2022-11-30 00:00:00-2022-12-31 00:00:00取数完成.........\n", "LY9139BBXMALBZ803-2022-01-31 00:00:00-2022-02-28 00:00:00开始取数.........\n", "Spend_time:2.6403727531433105 s\n", "LY9139BBXMALBZ803-2022-01-31 00:00:00-2022-02-28 00:00:00取数完成.........\n", "LY9139BBXMALBZ803-2022-02-28 00:00:00-2022-03-31 00:00:00开始取数.........\n", "Spend_time:3.3865089416503906 s\n", "LY9139BBXMALBZ803-2022-02-28 00:00:00-2022-03-31 00:00:00取数完成.........\n", "LY9139BBXMALBZ803-2022-03-31 00:00:00-2022-04-30 00:00:00开始取数.........\n", "Spend_time:3.118804454803467 s\n", "LY9139BBXMALBZ803-2022-03-31 00:00:00-2022-04-30 00:00:00取数完成.........\n", "LY9139BBXMALBZ803-2022-04-30 00:00:00-2022-05-31 00:00:00开始取数.........\n", "Spend_time:2.436645269393921 s\n", "LY9139BBXMALBZ803-2022-04-30 00:00:00-2022-05-31 00:00:00取数完成.........\n", "LY9139BBXMALBZ803-2022-05-31 00:00:00-2022-06-30 00:00:00开始取数.........\n", "Spend_time:2.991393566131592 s\n", "LY9139BBXMALBZ803-2022-05-31 00:00:00-2022-06-30 00:00:00取数完成.........\n", "LY9139BBXMALBZ803-2022-06-30 00:00:00-2022-07-31 00:00:00开始取数.........\n", "Spend_time:3.5996360778808594 s\n", "LY9139BBXMALBZ803-2022-06-30 00:00:00-2022-07-31 00:00:00取数完成.........\n", "LY9139BBXMALBZ803-2022-07-31 00:00:00-2022-08-31 00:00:00开始取数.........\n", "Spend_time:2.505887031555176 s\n", "LY9139BBXMALBZ803-2022-07-31 00:00:00-2022-08-31 00:00:00取数完成.........\n", "LY9139BBXMALBZ803-2022-08-31 00:00:00-2022-09-30 00:00:00开始取数.........\n", "Traceback (most recent call last):\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/ZlwlAlgosCommon/impl/DBHbase.py\", line 58, in page_query\n", " last_rows = self.cursor.fetchall()\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/cursor.py\", line 338, in fetchall\n", " row = self.fetchone()\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/cursor.py\", line 320, in fetchone\n", " self._fetch_next_frame()\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/cursor.py\", line 160, in _fetch_next_frame\n", " frame = self._connection._client.fetch(\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/avatica/client.py\", line 595, in fetch\n", " response_data = self._apply(request)\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/avatica/client.py\", line 227, in _apply\n", " parse_error_protobuf(response_body)\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/avatica/client.py\", line 127, in parse_error_protobuf\n", " parse_and_raise_sql_error(err.error_message)\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/avatica/client.py\", line 103, in parse_and_raise_sql_error\n", " raise_sql_error(int(code), sqlstate, message)\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/avatica/client.py\", line 96, in raise_sql_error\n", " raise errors.InternalError(message, code, sqlstate)\n", "phoenixdb.errors.InternalError: ('ResultSet is closed.', 1101, 'XCL01', None)\n", "\n", "---------WARNING: HBASE 获取数据出现异常, 开始第1次重试....\n", "连接hbase数据库\n", "连接hbase数据库 成功\n", "Spend_time:3.9664671421051025 s\n", "LY9139BBXMALBZ803-2022-08-31 00:00:00-2022-09-30 00:00:00取数完成.........\n", "LY9139BBXMALBZ803-2022-09-30 00:00:00-2022-10-31 00:00:00开始取数.........\n", "Spend_time:2.820211410522461 s\n", "LY9139BBXMALBZ803-2022-09-30 00:00:00-2022-10-31 00:00:00取数完成.........\n", "LY9139BBXMALBZ803-2022-10-31 00:00:00-2022-11-30 00:00:00开始取数.........\n", "Spend_time:4.2213287353515625 s\n", "LY9139BBXMALBZ803-2022-10-31 00:00:00-2022-11-30 00:00:00取数完成.........\n", "LY9139BBXMALBZ803-2022-11-30 00:00:00-2022-12-31 00:00:00开始取数.........\n", "Spend_time:0.5683290958404541 s\n", "LY9139BBXMALBZ803-2022-11-30 00:00:00-2022-12-31 00:00:00取数完成.........\n", "LY9F49BC1MALBZ877-2022-01-31 00:00:00-2022-02-28 00:00:00开始取数.........\n", "Spend_time:7.4455976486206055 s\n", "LY9F49BC1MALBZ877-2022-01-31 00:00:00-2022-02-28 00:00:00取数完成.........\n", "LY9F49BC1MALBZ877-2022-02-28 00:00:00-2022-03-31 00:00:00开始取数.........\n", "Spend_time:7.783544063568115 s\n", "LY9F49BC1MALBZ877-2022-02-28 00:00:00-2022-03-31 00:00:00取数完成.........\n", "LY9F49BC1MALBZ877-2022-03-31 00:00:00-2022-04-30 00:00:00开始取数.........\n", "Spend_time:12.707138538360596 s\n", "LY9F49BC1MALBZ877-2022-03-31 00:00:00-2022-04-30 00:00:00取数完成.........\n", "LY9F49BC1MALBZ877-2022-04-30 00:00:00-2022-05-31 00:00:00开始取数.........\n", "Spend_time:13.374231815338135 s\n", "LY9F49BC1MALBZ877-2022-04-30 00:00:00-2022-05-31 00:00:00取数完成.........\n", "LY9F49BC1MALBZ877-2022-05-31 00:00:00-2022-06-30 00:00:00开始取数.........\n", "Spend_time:6.488880395889282 s\n", "LY9F49BC1MALBZ877-2022-05-31 00:00:00-2022-06-30 00:00:00取数完成.........\n", "LY9F49BC1MALBZ877-2022-06-30 00:00:00-2022-07-31 00:00:00开始取数.........\n", "Spend_time:7.668222904205322 s\n", "LY9F49BC1MALBZ877-2022-06-30 00:00:00-2022-07-31 00:00:00取数完成.........\n", "LY9F49BC1MALBZ877-2022-07-31 00:00:00-2022-08-31 00:00:00开始取数.........\n", "Spend_time:9.644651651382446 s\n", "LY9F49BC1MALBZ877-2022-07-31 00:00:00-2022-08-31 00:00:00取数完成.........\n", "LY9F49BC1MALBZ877-2022-08-31 00:00:00-2022-09-30 00:00:00开始取数.........\n", "Spend_time:7.109942197799683 s\n", "LY9F49BC1MALBZ877-2022-08-31 00:00:00-2022-09-30 00:00:00取数完成.........\n", "LY9F49BC1MALBZ877-2022-09-30 00:00:00-2022-10-31 00:00:00开始取数.........\n", "Spend_time:8.351942300796509 s\n", "LY9F49BC1MALBZ877-2022-09-30 00:00:00-2022-10-31 00:00:00取数完成.........\n", "LY9F49BC1MALBZ877-2022-10-31 00:00:00-2022-11-30 00:00:00开始取数.........\n", "Spend_time:7.881471157073975 s\n", "LY9F49BC1MALBZ877-2022-10-31 00:00:00-2022-11-30 00:00:00取数完成.........\n", "LY9F49BC1MALBZ877-2022-11-30 00:00:00-2022-12-31 00:00:00开始取数.........\n", "Spend_time:0.730506181716919 s\n", "LY9F49BC1MALBZ877-2022-11-30 00:00:00-2022-12-31 00:00:00取数完成.........\n", "LY9F49BC3MALBZ878-2022-01-31 00:00:00-2022-02-28 00:00:00开始取数.........\n", "Spend_time:5.348378658294678 s\n", "LY9F49BC3MALBZ878-2022-01-31 00:00:00-2022-02-28 00:00:00取数完成.........\n", "LY9F49BC3MALBZ878-2022-02-28 00:00:00-2022-03-31 00:00:00开始取数.........\n", "Spend_time:8.452457189559937 s\n", "LY9F49BC3MALBZ878-2022-02-28 00:00:00-2022-03-31 00:00:00取数完成.........\n", "LY9F49BC3MALBZ878-2022-03-31 00:00:00-2022-04-30 00:00:00开始取数.........\n", "Spend_time:7.674983978271484 s\n", "LY9F49BC3MALBZ878-2022-03-31 00:00:00-2022-04-30 00:00:00取数完成.........\n", "LY9F49BC3MALBZ878-2022-04-30 00:00:00-2022-05-31 00:00:00开始取数.........\n", "Spend_time:11.354932308197021 s\n", "LY9F49BC3MALBZ878-2022-04-30 00:00:00-2022-05-31 00:00:00取数完成.........\n", "LY9F49BC3MALBZ878-2022-05-31 00:00:00-2022-06-30 00:00:00开始取数.........\n", "Spend_time:7.202967643737793 s\n", "LY9F49BC3MALBZ878-2022-05-31 00:00:00-2022-06-30 00:00:00取数完成.........\n", "LY9F49BC3MALBZ878-2022-06-30 00:00:00-2022-07-31 00:00:00开始取数.........\n", "Spend_time:11.916749954223633 s\n", "LY9F49BC3MALBZ878-2022-06-30 00:00:00-2022-07-31 00:00:00取数完成.........\n", "LY9F49BC3MALBZ878-2022-07-31 00:00:00-2022-08-31 00:00:00开始取数.........\n", "Spend_time:6.290451765060425 s\n", "LY9F49BC3MALBZ878-2022-07-31 00:00:00-2022-08-31 00:00:00取数完成.........\n", "LY9F49BC3MALBZ878-2022-08-31 00:00:00-2022-09-30 00:00:00开始取数.........\n", "Spend_time:5.346652984619141 s\n", "LY9F49BC3MALBZ878-2022-08-31 00:00:00-2022-09-30 00:00:00取数完成.........\n", "LY9F49BC3MALBZ878-2022-09-30 00:00:00-2022-10-31 00:00:00开始取数.........\n", "Spend_time:9.935729503631592 s\n", "LY9F49BC3MALBZ878-2022-09-30 00:00:00-2022-10-31 00:00:00取数完成.........\n", "LY9F49BC3MALBZ878-2022-10-31 00:00:00-2022-11-30 00:00:00开始取数.........\n", "Spend_time:7.655931234359741 s\n", "LY9F49BC3MALBZ878-2022-10-31 00:00:00-2022-11-30 00:00:00取数完成.........\n", "LY9F49BC3MALBZ878-2022-11-30 00:00:00-2022-12-31 00:00:00开始取数.........\n", "Traceback (most recent call last):\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/ZlwlAlgosCommon/impl/DBHbase.py\", line 57, in page_query\n", " self.cursor.execute(new_sql)\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/cursor.py\", line 224, in execute\n", " results = self._connection._client.prepare_and_execute(\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/avatica/client.py\", line 461, in prepare_and_execute\n", " response_data = self._apply(request, 'ExecuteResponse')\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/avatica/client.py\", line 227, in _apply\n", " parse_error_protobuf(response_body)\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/avatica/client.py\", line 127, in parse_error_protobuf\n", " parse_and_raise_sql_error(err.error_message)\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/avatica/client.py\", line 103, in parse_and_raise_sql_error\n", " raise_sql_error(int(code), sqlstate, message)\n", " File \"/opt/module/anaconda2022-10/envs/py3916/lib/python3.9/site-packages/phoenixdb/avatica/client.py\", line 96, in raise_sql_error\n", " raise errors.InternalError(message, code, sqlstate)\n", "phoenixdb.errors.InternalError: ('Connectioin is closed.', 1111, 'XCL11', None)\n", "\n", "---------WARNING: HBASE 获取数据出现异常, 开始第1次重试....\n", "连接hbase数据库\n", "连接hbase数据库 成功\n", "Spend_time:0.6667838096618652 s\n", "LY9F49BC3MALBZ878-2022-11-30 00:00:00-2022-12-31 00:00:00取数完成.........\n", "LY9F49BC3MALBZ881-2022-01-31 00:00:00-2022-02-28 00:00:00开始取数.........\n", "Spend_time:5.426581621170044 s\n", "LY9F49BC3MALBZ881-2022-01-31 00:00:00-2022-02-28 00:00:00取数完成.........\n", "LY9F49BC3MALBZ881-2022-02-28 00:00:00-2022-03-31 00:00:00开始取数.........\n", "Spend_time:6.299723863601685 s\n", "LY9F49BC3MALBZ881-2022-02-28 00:00:00-2022-03-31 00:00:00取数完成.........\n", "LY9F49BC3MALBZ881-2022-03-31 00:00:00-2022-04-30 00:00:00开始取数.........\n", "Spend_time:6.291037559509277 s\n", "LY9F49BC3MALBZ881-2022-03-31 00:00:00-2022-04-30 00:00:00取数完成.........\n", "LY9F49BC3MALBZ881-2022-04-30 00:00:00-2022-05-31 00:00:00开始取数.........\n", "Spend_time:7.273330926895142 s\n", "LY9F49BC3MALBZ881-2022-04-30 00:00:00-2022-05-31 00:00:00取数完成.........\n", "LY9F49BC3MALBZ881-2022-05-31 00:00:00-2022-06-30 00:00:00开始取数.........\n", "Spend_time:6.060184001922607 s\n", "LY9F49BC3MALBZ881-2022-05-31 00:00:00-2022-06-30 00:00:00取数完成.........\n", "LY9F49BC3MALBZ881-2022-06-30 00:00:00-2022-07-31 00:00:00开始取数.........\n", "Spend_time:4.439151763916016 s\n", "LY9F49BC3MALBZ881-2022-06-30 00:00:00-2022-07-31 00:00:00取数完成.........\n", "LY9F49BC3MALBZ881-2022-07-31 00:00:00-2022-08-31 00:00:00开始取数.........\n", "Spend_time:6.087804794311523 s\n", "LY9F49BC3MALBZ881-2022-07-31 00:00:00-2022-08-31 00:00:00取数完成.........\n", "LY9F49BC3MALBZ881-2022-08-31 00:00:00-2022-09-30 00:00:00开始取数.........\n", "Spend_time:5.149416923522949 s\n", "LY9F49BC3MALBZ881-2022-08-31 00:00:00-2022-09-30 00:00:00取数完成.........\n", "LY9F49BC3MALBZ881-2022-09-30 00:00:00-2022-10-31 00:00:00开始取数.........\n", "Spend_time:7.151765823364258 s\n", "LY9F49BC3MALBZ881-2022-09-30 00:00:00-2022-10-31 00:00:00取数完成.........\n", "LY9F49BC3MALBZ881-2022-10-31 00:00:00-2022-11-30 00:00:00开始取数.........\n", "Spend_time:13.396957159042358 s\n", "LY9F49BC3MALBZ881-2022-10-31 00:00:00-2022-11-30 00:00:00取数完成.........\n", "LY9F49BC3MALBZ881-2022-11-30 00:00:00-2022-12-31 00:00:00开始取数.........\n", "Spend_time:0.6498963832855225 s\n", "LY9F49BC3MALBZ881-2022-11-30 00:00:00-2022-12-31 00:00:00取数完成.........\n", "LY9F49BC4MALBZ081-2022-01-31 00:00:00-2022-02-28 00:00:00开始取数.........\n", "Spend_time:2.5085043907165527 s\n", "LY9F49BC4MALBZ081-2022-01-31 00:00:00-2022-02-28 00:00:00取数完成.........\n", "LY9F49BC4MALBZ081-2022-02-28 00:00:00-2022-03-31 00:00:00开始取数.........\n", "Spend_time:2.8958687782287598 s\n", "LY9F49BC4MALBZ081-2022-02-28 00:00:00-2022-03-31 00:00:00取数完成.........\n", "LY9F49BC4MALBZ081-2022-03-31 00:00:00-2022-04-30 00:00:00开始取数.........\n", "Spend_time:0.44896864891052246 s\n", "LY9F49BC4MALBZ081-2022-03-31 00:00:00-2022-04-30 00:00:00取数完成.........\n", "LY9F49BC4MALBZ081-2022-04-30 00:00:00-2022-05-31 00:00:00开始取数.........\n", "Spend_time:0.8672900199890137 s\n", "LY9F49BC4MALBZ081-2022-04-30 00:00:00-2022-05-31 00:00:00取数完成.........\n", "LY9F49BC4MALBZ081-2022-05-31 00:00:00-2022-06-30 00:00:00开始取数.........\n", "Spend_time:2.9774346351623535 s\n", "LY9F49BC4MALBZ081-2022-05-31 00:00:00-2022-06-30 00:00:00取数完成.........\n", "LY9F49BC4MALBZ081-2022-06-30 00:00:00-2022-07-31 00:00:00开始取数.........\n", "Spend_time:5.521303653717041 s\n", "LY9F49BC4MALBZ081-2022-06-30 00:00:00-2022-07-31 00:00:00取数完成.........\n", "LY9F49BC4MALBZ081-2022-07-31 00:00:00-2022-08-31 00:00:00开始取数.........\n", "Spend_time:4.205287456512451 s\n", "LY9F49BC4MALBZ081-2022-07-31 00:00:00-2022-08-31 00:00:00取数完成.........\n", "LY9F49BC4MALBZ081-2022-08-31 00:00:00-2022-09-30 00:00:00开始取数.........\n", "Spend_time:1.0546000003814697 s\n", "LY9F49BC4MALBZ081-2022-08-31 00:00:00-2022-09-30 00:00:00取数完成.........\n", "LY9F49BC4MALBZ081-2022-09-30 00:00:00-2022-10-31 00:00:00开始取数.........\n", "Spend_time:2.633772373199463 s\n", "LY9F49BC4MALBZ081-2022-09-30 00:00:00-2022-10-31 00:00:00取数完成.........\n", "LY9F49BC4MALBZ081-2022-10-31 00:00:00-2022-11-30 00:00:00开始取数.........\n", "Spend_time:4.0940351486206055 s\n", "LY9F49BC4MALBZ081-2022-10-31 00:00:00-2022-11-30 00:00:00取数完成.........\n", "LY9F49BC4MALBZ081-2022-11-30 00:00:00-2022-12-31 00:00:00开始取数.........\n", "Spend_time:0.29012179374694824 s\n", "LY9F49BC4MALBZ081-2022-11-30 00:00:00-2022-12-31 00:00:00取数完成.........\n", "LY9F49BC4MALBZ470-2022-01-31 00:00:00-2022-02-28 00:00:00开始取数.........\n", "Spend_time:3.611029863357544 s\n", "LY9F49BC4MALBZ470-2022-01-31 00:00:00-2022-02-28 00:00:00取数完成.........\n", "LY9F49BC4MALBZ470-2022-02-28 00:00:00-2022-03-31 00:00:00开始取数.........\n", "Spend_time:4.077031135559082 s\n", "LY9F49BC4MALBZ470-2022-02-28 00:00:00-2022-03-31 00:00:00取数完成.........\n", "LY9F49BC4MALBZ470-2022-03-31 00:00:00-2022-04-30 00:00:00开始取数.........\n", "Spend_time:3.7606558799743652 s\n", "LY9F49BC4MALBZ470-2022-03-31 00:00:00-2022-04-30 00:00:00取数完成.........\n", "LY9F49BC4MALBZ470-2022-04-30 00:00:00-2022-05-31 00:00:00开始取数.........\n", "Spend_time:4.149298667907715 s\n", "LY9F49BC4MALBZ470-2022-04-30 00:00:00-2022-05-31 00:00:00取数完成.........\n", "LY9F49BC4MALBZ470-2022-05-31 00:00:00-2022-06-30 00:00:00开始取数.........\n", "Spend_time:6.51824426651001 s\n", "LY9F49BC4MALBZ470-2022-05-31 00:00:00-2022-06-30 00:00:00取数完成.........\n", "LY9F49BC4MALBZ470-2022-06-30 00:00:00-2022-07-31 00:00:00开始取数.........\n", "Spend_time:7.156651020050049 s\n", "LY9F49BC4MALBZ470-2022-06-30 00:00:00-2022-07-31 00:00:00取数完成.........\n", "LY9F49BC4MALBZ470-2022-07-31 00:00:00-2022-08-31 00:00:00开始取数.........\n", "Spend_time:6.286117076873779 s\n", "LY9F49BC4MALBZ470-2022-07-31 00:00:00-2022-08-31 00:00:00取数完成.........\n", "LY9F49BC4MALBZ470-2022-08-31 00:00:00-2022-09-30 00:00:00开始取数.........\n", "Spend_time:6.677847385406494 s\n", "LY9F49BC4MALBZ470-2022-08-31 00:00:00-2022-09-30 00:00:00取数完成.........\n", "LY9F49BC4MALBZ470-2022-09-30 00:00:00-2022-10-31 00:00:00开始取数.........\n", "Spend_time:6.5250773429870605 s\n", "LY9F49BC4MALBZ470-2022-09-30 00:00:00-2022-10-31 00:00:00取数完成.........\n", "LY9F49BC4MALBZ470-2022-10-31 00:00:00-2022-11-30 00:00:00开始取数.........\n", "Spend_time:9.828088760375977 s\n", "LY9F49BC4MALBZ470-2022-10-31 00:00:00-2022-11-30 00:00:00取数完成.........\n", "LY9F49BC4MALBZ470-2022-11-30 00:00:00-2022-12-31 00:00:00开始取数.........\n", "Spend_time:0.5724518299102783 s\n", "LY9F49BC4MALBZ470-2022-11-30 00:00:00-2022-12-31 00:00:00取数完成.........\n", "LY9F49BC5MALBZ364-2022-01-31 00:00:00-2022-02-28 00:00:00开始取数.........\n", "Spend_time:3.2564051151275635 s\n", "LY9F49BC5MALBZ364-2022-01-31 00:00:00-2022-02-28 00:00:00取数完成.........\n", "LY9F49BC5MALBZ364-2022-02-28 00:00:00-2022-03-31 00:00:00开始取数.........\n", "Spend_time:8.77017092704773 s\n", "LY9F49BC5MALBZ364-2022-02-28 00:00:00-2022-03-31 00:00:00取数完成.........\n", "LY9F49BC5MALBZ364-2022-03-31 00:00:00-2022-04-30 00:00:00开始取数.........\n", "Spend_time:5.666677951812744 s\n", "LY9F49BC5MALBZ364-2022-03-31 00:00:00-2022-04-30 00:00:00取数完成.........\n", "LY9F49BC5MALBZ364-2022-04-30 00:00:00-2022-05-31 00:00:00开始取数.........\n", "Spend_time:6.873310327529907 s\n", "LY9F49BC5MALBZ364-2022-04-30 00:00:00-2022-05-31 00:00:00取数完成.........\n", "LY9F49BC5MALBZ364-2022-05-31 00:00:00-2022-06-30 00:00:00开始取数.........\n", "Spend_time:7.132760763168335 s\n", "LY9F49BC5MALBZ364-2022-05-31 00:00:00-2022-06-30 00:00:00取数完成.........\n", "LY9F49BC5MALBZ364-2022-06-30 00:00:00-2022-07-31 00:00:00开始取数.........\n", "Spend_time:9.193212509155273 s\n", "LY9F49BC5MALBZ364-2022-06-30 00:00:00-2022-07-31 00:00:00取数完成.........\n", "LY9F49BC5MALBZ364-2022-07-31 00:00:00-2022-08-31 00:00:00开始取数.........\n", "Spend_time:6.63126540184021 s\n", "LY9F49BC5MALBZ364-2022-07-31 00:00:00-2022-08-31 00:00:00取数完成.........\n", "LY9F49BC5MALBZ364-2022-08-31 00:00:00-2022-09-30 00:00:00开始取数.........\n", "Spend_time:8.039605379104614 s\n", "LY9F49BC5MALBZ364-2022-08-31 00:00:00-2022-09-30 00:00:00取数完成.........\n", "LY9F49BC5MALBZ364-2022-09-30 00:00:00-2022-10-31 00:00:00开始取数.........\n", "Spend_time:5.772777795791626 s\n", "LY9F49BC5MALBZ364-2022-09-30 00:00:00-2022-10-31 00:00:00取数完成.........\n", "LY9F49BC5MALBZ364-2022-10-31 00:00:00-2022-11-30 00:00:00开始取数.........\n", "Spend_time:3.770202159881592 s\n", "LY9F49BC5MALBZ364-2022-10-31 00:00:00-2022-11-30 00:00:00取数完成.........\n", "LY9F49BC5MALBZ364-2022-11-30 00:00:00-2022-12-31 00:00:00开始取数.........\n", "Spend_time:0.0003368854522705078 s\n", "LY9F49BC5MALBZ364-2022-11-30 00:00:00-2022-12-31 00:00:00取数完成.........\n", "\"None of [Index(['time', 'sn', 'latitude', 'longitude'], dtype='object')] are in the [columns]\"\n", "LY9F49BC5MALBZ879-2022-01-31 00:00:00-2022-02-28 00:00:00开始取数.........\n", "Spend_time:5.271116495132446 s\n", "LY9F49BC5MALBZ879-2022-01-31 00:00:00-2022-02-28 00:00:00取数完成.........\n", "LY9F49BC5MALBZ879-2022-02-28 00:00:00-2022-03-31 00:00:00开始取数.........\n", "Spend_time:7.097232103347778 s\n", "LY9F49BC5MALBZ879-2022-02-28 00:00:00-2022-03-31 00:00:00取数完成.........\n", "LY9F49BC5MALBZ879-2022-03-31 00:00:00-2022-04-30 00:00:00开始取数.........\n", "Spend_time:7.378749370574951 s\n", "LY9F49BC5MALBZ879-2022-03-31 00:00:00-2022-04-30 00:00:00取数完成.........\n", "LY9F49BC5MALBZ879-2022-04-30 00:00:00-2022-05-31 00:00:00开始取数.........\n", "Spend_time:9.301413536071777 s\n", "LY9F49BC5MALBZ879-2022-04-30 00:00:00-2022-05-31 00:00:00取数完成.........\n", "LY9F49BC5MALBZ879-2022-05-31 00:00:00-2022-06-30 00:00:00开始取数.........\n", "Spend_time:6.900826454162598 s\n", "LY9F49BC5MALBZ879-2022-05-31 00:00:00-2022-06-30 00:00:00取数完成.........\n", "LY9F49BC5MALBZ879-2022-06-30 00:00:00-2022-07-31 00:00:00开始取数.........\n", "Spend_time:10.428663969039917 s\n", "LY9F49BC5MALBZ879-2022-06-30 00:00:00-2022-07-31 00:00:00取数完成.........\n", "LY9F49BC5MALBZ879-2022-07-31 00:00:00-2022-08-31 00:00:00开始取数.........\n", "Spend_time:5.423503875732422 s\n", "LY9F49BC5MALBZ879-2022-07-31 00:00:00-2022-08-31 00:00:00取数完成.........\n", "LY9F49BC5MALBZ879-2022-08-31 00:00:00-2022-09-30 00:00:00开始取数.........\n", "Spend_time:4.50888991355896 s\n", "LY9F49BC5MALBZ879-2022-08-31 00:00:00-2022-09-30 00:00:00取数完成.........\n", "LY9F49BC5MALBZ879-2022-09-30 00:00:00-2022-10-31 00:00:00开始取数.........\n", "Spend_time:7.613963842391968 s\n", "LY9F49BC5MALBZ879-2022-09-30 00:00:00-2022-10-31 00:00:00取数完成.........\n", "LY9F49BC5MALBZ879-2022-10-31 00:00:00-2022-11-30 00:00:00开始取数.........\n", "Spend_time:7.177842617034912 s\n", "LY9F49BC5MALBZ879-2022-10-31 00:00:00-2022-11-30 00:00:00取数完成.........\n", "LY9F49BC5MALBZ879-2022-11-30 00:00:00-2022-12-31 00:00:00开始取数.........\n", "Spend_time:0.7044529914855957 s\n", "LY9F49BC5MALBZ879-2022-11-30 00:00:00-2022-12-31 00:00:00取数完成.........\n", "LY9F49BC5MALBZ882-2022-01-31 00:00:00-2022-02-28 00:00:00开始取数.........\n", "Spend_time:6.170802116394043 s\n", "LY9F49BC5MALBZ882-2022-01-31 00:00:00-2022-02-28 00:00:00取数完成.........\n", "LY9F49BC5MALBZ882-2022-02-28 00:00:00-2022-03-31 00:00:00开始取数.........\n", "Spend_time:10.638843059539795 s\n", "LY9F49BC5MALBZ882-2022-02-28 00:00:00-2022-03-31 00:00:00取数完成.........\n", "LY9F49BC5MALBZ882-2022-03-31 00:00:00-2022-04-30 00:00:00开始取数.........\n", "Spend_time:7.081163167953491 s\n", "LY9F49BC5MALBZ882-2022-03-31 00:00:00-2022-04-30 00:00:00取数完成.........\n", "LY9F49BC5MALBZ882-2022-04-30 00:00:00-2022-05-31 00:00:00开始取数.........\n", "Spend_time:8.259401798248291 s\n", "LY9F49BC5MALBZ882-2022-04-30 00:00:00-2022-05-31 00:00:00取数完成.........\n", "LY9F49BC5MALBZ882-2022-05-31 00:00:00-2022-06-30 00:00:00开始取数.........\n", "Spend_time:6.847156763076782 s\n", "LY9F49BC5MALBZ882-2022-05-31 00:00:00-2022-06-30 00:00:00取数完成.........\n", "LY9F49BC5MALBZ882-2022-06-30 00:00:00-2022-07-31 00:00:00开始取数.........\n", "Spend_time:7.201180696487427 s\n", "LY9F49BC5MALBZ882-2022-06-30 00:00:00-2022-07-31 00:00:00取数完成.........\n", "LY9F49BC5MALBZ882-2022-07-31 00:00:00-2022-08-31 00:00:00开始取数.........\n", "Spend_time:8.599934577941895 s\n", "LY9F49BC5MALBZ882-2022-07-31 00:00:00-2022-08-31 00:00:00取数完成.........\n", "LY9F49BC5MALBZ882-2022-08-31 00:00:00-2022-09-30 00:00:00开始取数.........\n", "Spend_time:5.771709442138672 s\n", "LY9F49BC5MALBZ882-2022-08-31 00:00:00-2022-09-30 00:00:00取数完成.........\n", "LY9F49BC5MALBZ882-2022-09-30 00:00:00-2022-10-31 00:00:00开始取数.........\n", "Spend_time:8.005459070205688 s\n", "LY9F49BC5MALBZ882-2022-09-30 00:00:00-2022-10-31 00:00:00取数完成.........\n", "LY9F49BC5MALBZ882-2022-10-31 00:00:00-2022-11-30 00:00:00开始取数.........\n", "Spend_time:11.533963203430176 s\n", "LY9F49BC5MALBZ882-2022-10-31 00:00:00-2022-11-30 00:00:00取数完成.........\n", "LY9F49BC5MALBZ882-2022-11-30 00:00:00-2022-12-31 00:00:00开始取数.........\n", "Spend_time:0.6891582012176514 s\n", "LY9F49BC5MALBZ882-2022-11-30 00:00:00-2022-12-31 00:00:00取数完成.........\n", "LY9F49BC7MALBZ480-2022-01-31 00:00:00-2022-02-28 00:00:00开始取数.........\n", "Spend_time:5.536253929138184 s\n", "LY9F49BC7MALBZ480-2022-01-31 00:00:00-2022-02-28 00:00:00取数完成.........\n", "LY9F49BC7MALBZ480-2022-02-28 00:00:00-2022-03-31 00:00:00开始取数.........\n", "Spend_time:7.213713645935059 s\n", "LY9F49BC7MALBZ480-2022-02-28 00:00:00-2022-03-31 00:00:00取数完成.........\n", "LY9F49BC7MALBZ480-2022-03-31 00:00:00-2022-04-30 00:00:00开始取数.........\n", "Spend_time:5.426680564880371 s\n", "LY9F49BC7MALBZ480-2022-03-31 00:00:00-2022-04-30 00:00:00取数完成.........\n", "LY9F49BC7MALBZ480-2022-04-30 00:00:00-2022-05-31 00:00:00开始取数.........\n", "Spend_time:5.166414260864258 s\n", "LY9F49BC7MALBZ480-2022-04-30 00:00:00-2022-05-31 00:00:00取数完成.........\n", "LY9F49BC7MALBZ480-2022-05-31 00:00:00-2022-06-30 00:00:00开始取数.........\n", "Spend_time:5.561408519744873 s\n", "LY9F49BC7MALBZ480-2022-05-31 00:00:00-2022-06-30 00:00:00取数完成.........\n", "LY9F49BC7MALBZ480-2022-06-30 00:00:00-2022-07-31 00:00:00开始取数.........\n", "Spend_time:7.181015729904175 s\n", "LY9F49BC7MALBZ480-2022-06-30 00:00:00-2022-07-31 00:00:00取数完成.........\n", "LY9F49BC7MALBZ480-2022-07-31 00:00:00-2022-08-31 00:00:00开始取数.........\n", "Spend_time:7.992786884307861 s\n", "LY9F49BC7MALBZ480-2022-07-31 00:00:00-2022-08-31 00:00:00取数完成.........\n", "LY9F49BC7MALBZ480-2022-08-31 00:00:00-2022-09-30 00:00:00开始取数.........\n", "Spend_time:7.521278381347656 s\n", "LY9F49BC7MALBZ480-2022-08-31 00:00:00-2022-09-30 00:00:00取数完成.........\n", "LY9F49BC7MALBZ480-2022-09-30 00:00:00-2022-10-31 00:00:00开始取数.........\n", "Spend_time:7.067009925842285 s\n", "LY9F49BC7MALBZ480-2022-09-30 00:00:00-2022-10-31 00:00:00取数完成.........\n", "LY9F49BC7MALBZ480-2022-10-31 00:00:00-2022-11-30 00:00:00开始取数.........\n", "Spend_time:6.873050689697266 s\n", "LY9F49BC7MALBZ480-2022-10-31 00:00:00-2022-11-30 00:00:00取数完成.........\n", "LY9F49BC7MALBZ480-2022-11-30 00:00:00-2022-12-31 00:00:00开始取数.........\n", "Spend_time:0.7196090221405029 s\n", "LY9F49BC7MALBZ480-2022-11-30 00:00:00-2022-12-31 00:00:00取数完成.........\n", "LY9F49BC7MALBZ883-2022-01-31 00:00:00-2022-02-28 00:00:00开始取数.........\n", "Spend_time:6.742255687713623 s\n", "LY9F49BC7MALBZ883-2022-01-31 00:00:00-2022-02-28 00:00:00取数完成.........\n", "LY9F49BC7MALBZ883-2022-02-28 00:00:00-2022-03-31 00:00:00开始取数.........\n", "Spend_time:7.969898700714111 s\n", "LY9F49BC7MALBZ883-2022-02-28 00:00:00-2022-03-31 00:00:00取数完成.........\n", "LY9F49BC7MALBZ883-2022-03-31 00:00:00-2022-04-30 00:00:00开始取数.........\n", "Spend_time:7.438252687454224 s\n", "LY9F49BC7MALBZ883-2022-03-31 00:00:00-2022-04-30 00:00:00取数完成.........\n", "LY9F49BC7MALBZ883-2022-04-30 00:00:00-2022-05-31 00:00:00开始取数.........\n", "Spend_time:8.615233659744263 s\n", "LY9F49BC7MALBZ883-2022-04-30 00:00:00-2022-05-31 00:00:00取数完成.........\n", "LY9F49BC7MALBZ883-2022-05-31 00:00:00-2022-06-30 00:00:00开始取数.........\n", "Spend_time:7.448206663131714 s\n", "LY9F49BC7MALBZ883-2022-05-31 00:00:00-2022-06-30 00:00:00取数完成.........\n", "LY9F49BC7MALBZ883-2022-06-30 00:00:00-2022-07-31 00:00:00开始取数.........\n", "Spend_time:10.878441572189331 s\n", "LY9F49BC7MALBZ883-2022-06-30 00:00:00-2022-07-31 00:00:00取数完成.........\n", "LY9F49BC7MALBZ883-2022-07-31 00:00:00-2022-08-31 00:00:00开始取数.........\n", "Spend_time:8.216920614242554 s\n", "LY9F49BC7MALBZ883-2022-07-31 00:00:00-2022-08-31 00:00:00取数完成.........\n", "LY9F49BC7MALBZ883-2022-08-31 00:00:00-2022-09-30 00:00:00开始取数.........\n", "Spend_time:6.197717189788818 s\n", "LY9F49BC7MALBZ883-2022-08-31 00:00:00-2022-09-30 00:00:00取数完成.........\n", "LY9F49BC7MALBZ883-2022-09-30 00:00:00-2022-10-31 00:00:00开始取数.........\n", "Spend_time:8.13144040107727 s\n", "LY9F49BC7MALBZ883-2022-09-30 00:00:00-2022-10-31 00:00:00取数完成.........\n", "LY9F49BC7MALBZ883-2022-10-31 00:00:00-2022-11-30 00:00:00开始取数.........\n", "Spend_time:9.603691816329956 s\n", "LY9F49BC7MALBZ883-2022-10-31 00:00:00-2022-11-30 00:00:00取数完成.........\n", "LY9F49BC7MALBZ883-2022-11-30 00:00:00-2022-12-31 00:00:00开始取数.........\n", "Spend_time:0.4341888427734375 s\n", "LY9F49BC7MALBZ883-2022-11-30 00:00:00-2022-12-31 00:00:00取数完成.........\n", "LY9F49BC8MALBZ083-2022-01-31 00:00:00-2022-02-28 00:00:00开始取数.........\n", "Spend_time:1.7922940254211426 s\n", "LY9F49BC8MALBZ083-2022-01-31 00:00:00-2022-02-28 00:00:00取数完成.........\n", "LY9F49BC8MALBZ083-2022-02-28 00:00:00-2022-03-31 00:00:00开始取数.........\n", "Spend_time:5.194387674331665 s\n", "LY9F49BC8MALBZ083-2022-02-28 00:00:00-2022-03-31 00:00:00取数完成.........\n", "LY9F49BC8MALBZ083-2022-03-31 00:00:00-2022-04-30 00:00:00开始取数.........\n", "Spend_time:1.6036126613616943 s\n", "LY9F49BC8MALBZ083-2022-03-31 00:00:00-2022-04-30 00:00:00取数完成.........\n", "LY9F49BC8MALBZ083-2022-04-30 00:00:00-2022-05-31 00:00:00开始取数.........\n", "Spend_time:1.0748798847198486 s\n", "LY9F49BC8MALBZ083-2022-04-30 00:00:00-2022-05-31 00:00:00取数完成.........\n", "LY9F49BC8MALBZ083-2022-05-31 00:00:00-2022-06-30 00:00:00开始取数.........\n", "Spend_time:2.7630040645599365 s\n", "LY9F49BC8MALBZ083-2022-05-31 00:00:00-2022-06-30 00:00:00取数完成.........\n", "LY9F49BC8MALBZ083-2022-06-30 00:00:00-2022-07-31 00:00:00开始取数.........\n", "Spend_time:5.0762224197387695 s\n", "LY9F49BC8MALBZ083-2022-06-30 00:00:00-2022-07-31 00:00:00取数完成.........\n", "LY9F49BC8MALBZ083-2022-07-31 00:00:00-2022-08-31 00:00:00开始取数.........\n", "Spend_time:3.1926991939544678 s\n", "LY9F49BC8MALBZ083-2022-07-31 00:00:00-2022-08-31 00:00:00取数完成.........\n", "LY9F49BC8MALBZ083-2022-08-31 00:00:00-2022-09-30 00:00:00开始取数.........\n", "Spend_time:0.9705946445465088 s\n", "LY9F49BC8MALBZ083-2022-08-31 00:00:00-2022-09-30 00:00:00取数完成.........\n", "LY9F49BC8MALBZ083-2022-09-30 00:00:00-2022-10-31 00:00:00开始取数.........\n", "Spend_time:3.143371820449829 s\n", "LY9F49BC8MALBZ083-2022-09-30 00:00:00-2022-10-31 00:00:00取数完成.........\n", "LY9F49BC8MALBZ083-2022-10-31 00:00:00-2022-11-30 00:00:00开始取数.........\n", "Spend_time:3.9117159843444824 s\n", "LY9F49BC8MALBZ083-2022-10-31 00:00:00-2022-11-30 00:00:00取数完成.........\n", "LY9F49BC8MALBZ083-2022-11-30 00:00:00-2022-12-31 00:00:00开始取数.........\n", "Spend_time:0.32245469093322754 s\n", "LY9F49BC8MALBZ083-2022-11-30 00:00:00-2022-12-31 00:00:00取数完成.........\n", "LY9F49BCXMALBZ876-2022-01-31 00:00:00-2022-02-28 00:00:00开始取数.........\n", "Spend_time:3.3189516067504883 s\n", "LY9F49BCXMALBZ876-2022-01-31 00:00:00-2022-02-28 00:00:00取数完成.........\n", "LY9F49BCXMALBZ876-2022-02-28 00:00:00-2022-03-31 00:00:00开始取数.........\n", "Spend_time:4.749475717544556 s\n", "LY9F49BCXMALBZ876-2022-02-28 00:00:00-2022-03-31 00:00:00取数完成.........\n", "LY9F49BCXMALBZ876-2022-03-31 00:00:00-2022-04-30 00:00:00开始取数.........\n", "Spend_time:4.591873407363892 s\n", "LY9F49BCXMALBZ876-2022-03-31 00:00:00-2022-04-30 00:00:00取数完成.........\n", "LY9F49BCXMALBZ876-2022-04-30 00:00:00-2022-05-31 00:00:00开始取数.........\n", "Spend_time:5.545069932937622 s\n", "LY9F49BCXMALBZ876-2022-04-30 00:00:00-2022-05-31 00:00:00取数完成.........\n", "LY9F49BCXMALBZ876-2022-05-31 00:00:00-2022-06-30 00:00:00开始取数.........\n", "Spend_time:5.718203544616699 s\n", "LY9F49BCXMALBZ876-2022-05-31 00:00:00-2022-06-30 00:00:00取数完成.........\n", "LY9F49BCXMALBZ876-2022-06-30 00:00:00-2022-07-31 00:00:00开始取数.........\n", "Spend_time:5.1039934158325195 s\n", "LY9F49BCXMALBZ876-2022-06-30 00:00:00-2022-07-31 00:00:00取数完成.........\n", "LY9F49BCXMALBZ876-2022-07-31 00:00:00-2022-08-31 00:00:00开始取数.........\n", "Spend_time:4.715943098068237 s\n", "LY9F49BCXMALBZ876-2022-07-31 00:00:00-2022-08-31 00:00:00取数完成.........\n", "LY9F49BCXMALBZ876-2022-08-31 00:00:00-2022-09-30 00:00:00开始取数.........\n", "Spend_time:4.267485857009888 s\n", "LY9F49BCXMALBZ876-2022-08-31 00:00:00-2022-09-30 00:00:00取数完成.........\n", "LY9F49BCXMALBZ876-2022-09-30 00:00:00-2022-10-31 00:00:00开始取数.........\n", "Spend_time:5.421348333358765 s\n", "LY9F49BCXMALBZ876-2022-09-30 00:00:00-2022-10-31 00:00:00取数完成.........\n", "LY9F49BCXMALBZ876-2022-10-31 00:00:00-2022-11-30 00:00:00开始取数.........\n", "Spend_time:5.622807741165161 s\n", "LY9F49BCXMALBZ876-2022-10-31 00:00:00-2022-11-30 00:00:00取数完成.........\n", "LY9F49BCXMALBZ876-2022-11-30 00:00:00-2022-12-31 00:00:00开始取数.........\n", "Spend_time:0.29636263847351074 s\n", "LY9F49BCXMALBZ876-2022-11-30 00:00:00-2022-12-31 00:00:00取数完成.........\n" ] } ], "source": [ "for sn in df_snpk_list[\"sn\"]:\n", " gps_last= pd.DataFrame()\n", " try:\n", " for k in range(0,len(st)):\n", " try:\n", " columns = [ DataField.time, DataField.sn,DataField.latitude,DataField.longitude]\n", " sn_list=[sn]\n", " df_data_get = iotp_service.get_data(sn_list=sn_list, columns=columns, start_time=st[k], end_time=et[k])\n", " df_gps=df_data_get[[\"time\",\"sn\",\"latitude\",\"longitude\"]]\n", " df_gps=df_gps.replace('',np.nan)\n", " df_gps=df_gps.dropna(axis=0,how='any')\n", " df_gps[\"latitude\"]=df_gps[\"latitude\"].astype(float)\n", " df_gps[\"longitude\"]=df_gps[\"longitude\"].astype(float)\n", " df_gps['time']=pd.to_datetime(df_gps['time'])\n", " df_gps[\"day\"]=df_gps[\"time\"].dt.date\n", " df_gps=df_gps.sort_values([\"sn\",\"time\"],ascending = [True, True])\n", " mon=df_gps[[\"time\",\"latitude\",\"longitude\",\"sn\",\"day\"]].groupby([\"sn\",\"day\"]).last()\n", " mon=mon.reset_index()\n", " gps_last=gps_last.append(mon)\n", " except Exception as e:\n", " print(e)\n", " gps_last.to_excel(\"gps_last_\"+str(sn)+\".xlsx\",index=False)\n", " P=gps_last[[\"latitude\",\"longitude\"]].values\n", " locations = P.tolist()\n", " zz=[ wgs_gcj(i[0], i[1]) for i in locations ]\n", " m = folium.Map(zz[0], zoom_start=16,\n", " tiles='http://webrd02.is.autonavi.com/appmaptile?lang=zh_cn&size=1&scale=1&style=7&x={x}&y={y}&z={z}',\n", " attr='default')\n", " for i in range(len(zz)):\n", " folium.Marker(\n", " location=zz[i],\n", " popup='last location',\n", " icon=folium.Icon(color='blue', icon='cloud') # 标记颜色 图标\n", " ).add_to(m)\n", " m.save(\"trace_\"+str(sn)+\".html\")\n", " gps_last_t=gps_last_t.append(gps_last)\n", " except Exception as e:\n", " print(e)\n", "gps_last_t.to_excel(\"gps_last_t.xlsx\",index=False)\n", " " ] }, { "cell_type": "code", "execution_count": 101, "metadata": {}, "outputs": [], "source": [ "##总的" ] }, { "cell_type": "code", "execution_count": 102, "metadata": {}, "outputs": [], "source": [ "##读取总的停车点位置" ] }, { "cell_type": "code", "execution_count": 5, "metadata": {}, "outputs": [], "source": [ "df_gps_t=pd.read_excel(\"gps_last_t.xlsx\")" ] }, { "cell_type": "code", "execution_count": 6, "metadata": {}, "outputs": [], "source": [ "colors = ['aliceblue', 'antiquewhite', 'aqua', 'aquamarine', 'azure', 'beige', 'bisque', 'black', 'blanchedalmond', 'blue', 'blueviolet', 'brown', 'burlywood', 'cadetblue', 'chartreuse', 'chocolate', 'coral', 'cornflowerblue', 'cornsilk', 'crimson', 'cyan', 'darkblue', 'darkcyan', 'darkgoldenrod', 'darkgray', 'darkgreen', 'darkgrey', 'darkkhaki', 'darkmagenta', 'darkolivegreen', 'darkorange', 'darkorchid', 'darkred', 'darksalmon', 'darkseagreen', 'darkslateblue', 'darkslategray', 'darkslategrey', 'darkturquoise', 'darkviolet', 'deeppink', 'deepskyblue', 'dimgray', 'dimgrey', 'dodgerblue', 'firebrick', 'floralwhite', 'forestgreen', 'fuchsia', 'gainsboro', 'ghostwhite']" ] }, { "cell_type": "code", "execution_count": 7, "metadata": {}, "outputs": [], "source": [ "m = folium.Map([39.8125,118.164], zoom_start=16,\n", " tiles='http://webrd02.is.autonavi.com/appmaptile?lang=zh_cn&size=1&scale=1&style=7&x={x}&y={y}&z={z}',\n", " attr='default')" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "for i in range(len(df_snpk_list[\"sn\"])):\n", " sn=df_snpk_list[\"sn\"][i]\n", " color_id=colors[i]\n", " P=gps_last_t[[\"latitude\",\"longitude\"]][gps_last_t[\"sn\"]==sn]\n", " print(P.shape)\n", " P=P.values\n", " locations = P.tolist()\n", " zz=[ wgs_gcj(i[0], i[1]) for i in locations ]\n", " for j in range(len(zz)):\n", " folium.Marker(\n", " location=zz[j],\n", " popup='last location',\n", " icon=folium.Icon(color=color_id, icon='cloud') # 标记颜色 图标\n", " ).add_to(m)\n", "m.save(\"trace_t.html\")" ] }, { "cell_type": "code", "execution_count": 8, "metadata": {}, "outputs": [], "source": [ "##取每辆车最后一个点" ] }, { "cell_type": "code", "execution_count": 9, "metadata": {}, "outputs": [], "source": [ "df_gps_t=df_gps_t.sort_values([\"sn\",\"time\"],ascending = [True, True])\n", "mon=df_gps_t[[\"time\",\"latitude\",\"longitude\",\"sn\"]].groupby(\"sn\").last()" ] }, { "cell_type": "code", "execution_count": 11, "metadata": {}, "outputs": [], "source": [ "mon=mon.reset_index()" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ "mon" ] }, { "cell_type": "code", "execution_count": 13, "metadata": {}, "outputs": [], "source": [ "P=mon[[\"latitude\",\"longitude\"]].values\n", "locations = P.tolist()\n", "zz=[ wgs_gcj(i[0], i[1]) for i in locations ]\n", "m = folium.Map(zz[0], zoom_start=16,\n", " tiles='http://webrd02.is.autonavi.com/appmaptile?lang=zh_cn&size=1&scale=1&style=7&x={x}&y={y}&z={z}',\n", " attr='default')\n", "for i in range(len(zz)):\n", " folium.Marker(\n", " location=zz[i],\n", " popup='last location',\n", " icon=folium.Icon(color='blue', icon='cloud') # 标记颜色 图标\n", " ).add_to(m)\n", "m.save(\"trace_t_s.html\")" ] } ], "metadata": { "kernelspec": { "display_name": "py3916", "language": "python", "name": "python3" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 3 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "version": "3.9.16" }, "orig_nbformat": 4 }, "nbformat": 4, "nbformat_minor": 2 }