Support Questions
Find answers, ask questions, and share your expertise

analyze table test_dev_tr.ti_master_mapped_2 partition(tr_business_file_category='state',test_report_year=2018,test_report_month=2,test_report_day=21) compute statistics for columns; fails

Explorer

Running HDP 2.5.0.0

#Hive 1.2.1.2.5

YARN2.7.1.2.5

Tez0.7.0.2.5

[Dispatcher thread {Central}] |history.HistoryEventHandler|: [HISTORY][DAG:dag_1532611349318_0728_2][Event:TASK_ATTEMPT_FINISHED]: vertexName=Reducer 2, taskAttemptId=attempt_1532611349318_0728_2_01_000269_1, creationTime=1532945972705, allocationTime=1532945972711, startTime=1532945972779, finishTime=1532945973414, timeTaken=635, status=FAILED, errorEnum=FRAMEWORK_ERROR, diagnostics=Error: Failure while running task:java.lang.RuntimeException: org.apache.hadoop.hive.ql.metadata.HiveException: Hive Runtime Error while processing row (tag=0) {"key":{"_col0":"state","_col1":2017,"_col2":9,"_col3":29},"value":{"_col0":{"columntype":"String","maxlength":36,"sumlength":4175748,"count":115993,"countnulls":0,"bitvector":"{0}{0}{0}{0}{1}{1}{5}{1}{1}{2}{0}{0}{1}{2}{1}{1}","numbitvectors":16},"_col1":{"columntype":"Long","min":1532689330,"max":1532689330,"countnulls":0,"bitvector":"{0}{1}{0}{0}{1}{0}{0}{0}{0}{2}{1}{0}{0}{4}{0}{0}","numbitvectors":16},"_col2":{"columntype":"Long","min":229908,"max":345900,"countnulls":0,"bitvector":"{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 17, 20}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 13, 14, 15, 16, 17, 19}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 19}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 16, 18}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 18}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 14, 15, 16, 17, 18}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 22}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 17, 18, 22}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 20}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 19}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16}","numbitvectors":16},"_col3":{"columntype":"Long","min":1532945758,"max":1532945758,"countnulls":0,"bitvector":"{0}{4}{0}{0}{3}{2}{2}{0}{0}{1}{3}{2}{0}{1}{

{2}","numbitvectors":16},"_col4":{"columntype":"Date","min":"2017-09-30","max":"2017-09-30","countnulls":0,"bitvector":"{0}{0}{1}{0}{1}{3}{3}{0}{0}{0}{0}{0}{4}{1}{0}{2}","numbitvectors":16},"_col5":{"columntype":"String","maxlength":4,"sumlength":463972,"count":115993,"countnulls":0,"bitvector":"{6}{0}{3}{0}{0}{2}{1}{0}{0}{3}{0}{0}{0}{0}{2}{2}","numbitvectors":16},"_col6":{"columntype":"String","maxlength":12,"sumlength":1391916,"count":115993,"countnulls":0,"bitvector":"{0}{1}{0}{3}{1}{0}{1}{1}{0}{0}{0}{0}{0}{0}{1}{0}","numbitvectors":16},"_col7":{"columntype":"String","maxlength":46,"sumlength":5335678,"count":115993,"countnulls":0,"bitvector":"{0}{3}{0}{0}{5}{0}{1}{1}{1}{0}{3}{0}{1}{0}{0}{1}","numbitvectors":16},"_col8":{"columntype":"String","maxlength":20,"sumlength":2319860,"count":115993,"countnulls":0,"bitvector":"{0, 1, 2, 3, 4, 5, 6}{0, 1, 2, 3, 4, 5, 6, 7}{0, 1, 2, 3, 4, 5, 6, 7}{0, 1, 2, 3, 4, 5, 6}{0, 1, 2, 3, 4, 5, 6}{0, 1, 2, 3, 4, 5, 6, 10}{0, 1, 2, 3, 4, 5}{0, 1, 2, 3, 4, 5, 7, 8}{0, 1, 2, 3, 4, 5, 6, 7}{0, 1, 2, 3, 4, 5, 6}{0, 1, 2, 3, 4, 5, 6}{0, 1, 2, 3, 4, 5, 6, 8}{0, 1, 2, 3, 4, 5, 7, 9, 10}{0, 1, 2, 3, 4, 5, 6, 7}{0, 1, 2, 3, 4, 5}{0, 1, 2, 3, 4, 5, 6, 10}","numbitvectors":16},"_col9":{"columntype":"String","maxlength":116,"sumlength":2313536,"count":115993,"countnulls":0,"bitvector":"{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 11, 12, 13}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 13, 15}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 12}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 12}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 15}{0, 1, 2, 3, 4, 5, 6, 7, 8, 10, 11}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 14}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10}","numbitvectors":16},"_col10":{"columntype":"String","maxlength":1,"sumlength":115892,"count":115993,"countnulls":0,"bitvector":"{0, 2}{0, 3}{0}{0, 1}{0, 1}{0, 1, 2}{0}{0, 2}{0, 2, 5}{1}{1, 2}{1, 2}{0, 4}{1, 5}{0, 3}{0}","numbitvectors":16},"_col11":{"columntype":"String","maxlength":52,"sumlength":4549988,"count":115993,"countnulls":0,"bitvector":"{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 16, 18, 21}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 18}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 20}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 17}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 17}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 26}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 18}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 19, 20}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 19}","numbitvectors":16},"_col12":{"columntype":"String","maxlength":2,"sumlength":231986,"count":115993,"countnulls":0,"bitvector":"{0, 2}{1, 3}{1}{0}{0, 1}{0, 4}{0}{0, 1}{0, 1}{0, 1}{0, 4}{0, 2}{0}{0, 1}{0, 1}{0}","numbitvectors":16},"_col13":{"columntype":"String","maxlength":2,"sumlength":230654,"count":115327,"countnulls":666,"bitvector":"{0, 2}{0, 1, 2}{0, 1, 3}{0, 1, 2}{0}{0, 1}{0, 3}{0, 1}{0, 1}{0, 1, 2}{0, 5}{0}{0}{0, 1}{0, 1, 2}{0}","numbitvectors":16},"_col14":{"columntype":"String","maxlength":1,"sumlength":115993,"count":115993,"countnulls":0,"bitvector":"{0}{3}{1}{0}{4}{1}{0}{0}{0}{1}{1}{2}{3}{3}{0}{1}","numbitvectors":16},"_col15":{"columntype":"Decimal","min":0,"max":1136000000000,"countnulls":42,"bitvector":"{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 16}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 20}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 18}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 15}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 16}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 19}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 15, 16}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 16}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 15}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14}","numbitvectors":16},"_col16":{"columntype":"Decimal","min":0,"max":1136000000000,"countnulls":26968,"bitvector":"{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 20}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 15}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 13, 14, 15, 17}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 15}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 15, 16}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 15, 16}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 15}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 17}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13}","numbitvectors":16},"_col17":{"columntype":"Decimal","min":-0.9175,"max":17277126,"countnulls":62753,"bitvector":"{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 13, 16}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 16}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 14}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 11, 14, 15}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 13}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 14}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 13, 14}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 14}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 13}","numbitvectors":16},"_col18":{"columntype":"Decimal","min":-0.7175,"max":9999999999,"countnulls":61055,"bitvector":"{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 16}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 17}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 13}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 14}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 15}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 15}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 17}","numbitvectors":16},"_col19":{"columntype":"Decimal","min":-3870000000,"max":null,"countnulls":16,"bitvector":"","numbitvectors":0},"_col20":{"columntype":"Decimal","min":-199191000,"max":5000000000,"countnulls":109001,"bitvector":"{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 12}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 14, 15}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 12}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 15}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 16}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 14}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 13}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 17}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12}","numbitvectors":16},"_col21":{"columntype":"Decimal","min":0.01,"max":100,"countnulls":114,"bitvector":"{0, 1, 2}{0, 1, 2}{0, 5}{0, 1, 5}{0, 1, 2}{1, 2, 4}{0, 1, 9}{0, 1, 2}{0, 1, 4}{1}{0, 2}{0, 2, 3}{0, 6}{0, 1}{0, 1}{0, 1, 2}","numbitvectors":16},"_col22":{"columntype":"Decimal","min":-299994000,"max":175623713,"countnulls":73,"bitvector":"{0, 1, 2, 3, 4, 5, 6, 7, 8}{0, 1, 2, 3, 4, 5, 6, 7, 8}{0, 1, 2, 3, 4, 5, 6, 7, 9, 10}{0, 1, 2, 3, 4, 5, 6, 7, 8, 10, 12}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9}{0, 1, 2, 3, 4, 5, 6, 7, 13}{0, 1, 2, 3, 4, 5, 6, 7, 8}{0, 1, 2, 3, 4, 5, 6, 7, 12}{0, 1, 2, 3, 4, 5, 6, 8}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9}","numbitvectors":16},"_col23":{"columntype":"Decimal","min":-0.0101,"max":9999999999,"countnulls":111456,"bitvector":"{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10}{0, 1, 2, 3, 4, 5, 6, 7, 9}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 12}{0, 1, 2, 3, 4, 5, 6, 7, 8}{0, 1, 2, 3, 4, 5, 6, 7, 8, 10}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11}{0, 1, 2, 3, 4, 5, 6, 7, 8, 10}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 14}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 14}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12}{0, 1, 2, 3, 4, 5, 6, 7, 8, 12}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 11}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9}","numbitvectors":16},"_col24":{"columntype":"Date","min":"2006-03-31","max":"2095-12-21","countnulls":0,"bitvector":"{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 16}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 15}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 20}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 13}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 13, 15}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 14}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 14, 16}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 14}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14}","numbitvectors":16},"_col25":{"columntype":"Date","min":"1983-10-01","max":"2062-06-21","countnulls":1,"bitvector":"{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 12, 13}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 14}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 14}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 12, 20}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 13}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 13, 15}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 13, 14}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 13}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 12}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 14}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12}","numbitvectors":16},"_col26":{"columntype":"Date","min":"2006-08-24","max":"2017-09-29","countnulls":115754,"bitvector":"{0, 1, 2, 3, 4, 6, 10, 13}{0, 1, 2, 3, 4, 5, 6, 8}{0, 1, 2, 3, 4, 5}{0, 1, 2, 3, 4, 5, 6, 9}{0, 1, 2, 3, 4, 5, 6, 7}{0, 1, 2, 3, 4, 5, 6}{0, 1, 2, 3, 4, 5, 6, 7, 8}{0, 1, 2, 3, 4, 6, 7}{0, 1, 2, 3, 4, 5, 6, 7}{0, 1, 2, 3, 4, 5, 8}{0, 1, 2, 3, 4, 6}{0, 1, 2, 3, 4, 5, 6, 8}{0, 1, 2, 3, 4, 6, 9}{0, 1, 2, 3, 4, 5, 6, 7}{0, 1, 2, 3, 4, 5}{0, 1, 2, 3, 4, 5, 6, 7, 8}","numbitvectors":16},"_col27":{"columntype":"Date","min":"1999-05-26","max":"2067-06-30","countnulls":101172,"bitvector":"{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 12, 13}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 11}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 14}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 12}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 11, 12}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 20}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 13}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 11, 13, 15}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 14}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 11}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11}","numbitvectors":16},"_col28":{"columntype":"Long","min":-62135769600,"max":1512553898,"countnulls":51,"bitvector":"{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 16}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 19}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 16, 17}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 17}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 15}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 17, 18, 19}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 15}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 17, 20}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 18}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 18}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15}","numbitvectors":16},"_col29":{"columntype":"String","maxlength":3,"sumlength":347871,"count":115993,"countnulls":0,"bitvector":"{0, 1, 2, 3, 4, 7}{0, 1, 2, 3, 4, 7}{0, 1, 2, 3, 4, 5, 6}{0, 1, 2, 3, 4, 5}{0, 1, 2, 3, 4, 5}{0, 1, 2, 3, 4, 5, 6}{0, 1, 2, 3, 4, 6}{0, 1, 2, 3, 4}{0, 1, 2, 3, 4, 7}{0, 1, 2, 3}{0, 1, 2, 3, 7}{0, 1, 2, 3, 4}{0, 1, 2, 4, 5, 6}{0, 1, 2, 3, 4, 6}{0, 1, 2, 3, 4, 5}{0, 1, 2, 3, 4, 11}","numbitvectors":16},"_col30":{"columntype":"Long","min":1390675699,"max":1506724434,"countnulls":0,"bitvector":"{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 16, 17}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 19}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 16}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 18, 20}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 15, 16}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 16, 17}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 15}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16}","numbitvectors":16},"_col31":{"columntype":"String","maxlength":4,"sumlength":463972,"count":115993,"countnulls":0,"bitvector":"{2}{0}{0}{1}{0}{0}{1}{0}{1}{0}{2}{0}{0}{0}{0}{1}","numbitvectors":16},"_col32":{"columntype":"String","maxlength":3,"sumlength":347979,"count":115993,"countnulls":0,"bitvector":"{1}{0}{2}{1}{1}{6}{0}{0}{0}{0}{1}{2}{2}{1}{1}{2}","numbitvectors":16},"_col33":{"columntype":"String","maxlength":1,"sumlength":4169,"count":115993,"countnulls":0,"bitvector":"{0, 1}{0}{0, 1}{0, 1}{0, 1}{0, 4, 7}{0}{0, 1}{0, 1}{1}{0, 1, 2}{0, 1}{0, 1, 3}{0, 1}{0, 2}{0, 3}","numbitvectors":16},"_col34":{"columntype":"String","maxlength":12,"sumlength":1391916,"count":115993,"countnulls":0,"bitvector":"{0}{0}{3}{2}{0}{0}{5}{0}{0}{0}{0}{0}{2}{2}{1}{0}","numbitvectors":16},"_col35":{"columntype":"String","maxlength":2,"sumlength":231986,"count":115993,"countnulls":0,"bitvector":"{0, 2}{1, 3}{1}{0}{0, 1}{0, 4}{0}{0, 1}{0, 1}{0, 1}{0, 4}{0, 2}{0}{0, 1}{0, 1}{0}","numbitvectors":16},"_col36":{"columntype":"String","maxlength":2,"sumlength":230654,"count":115327,"countnulls":666,"bitvector":"{0, 2}{0, 1, 2}{0, 1, 3}{0, 1, 2}{0}{0, 1}{0, 3}{0, 1}{0, 1}{0, 1, 2}{0, 5}{0}{0}{0, 1}{0, 1, 2}{0}","numbitvectors":16},"_col37":{"columntype":"String","maxlength":3,"sumlength":267552,"count":115993,"countnulls":0,"bitvector":"{0, 1, 2, 3, 4, 7}{0, 1, 2, 3, 4}{0, 1, 2, 3, 4, 5, 6}{0, 1, 2, 3, 5}{0, 1, 2, 3, 4, 5}{0, 1, 2, 3, 4, 5, 6}{0, 1, 2, 3, 4, 6}{0, 1, 2, 3, 4, 5}{0, 1, 2, 3, 7}{0, 1, 2, 3}{0, 1, 2, 3, 7}{0, 1, 2, 3, 4}{0, 1, 2, 4, 5, 6}{0, 1, 2, 3, 4, 6}{0, 1, 2, 3, 4}{0, 1, 2, 3, 4, 11}","numbitvectors":16},"_col38":{"columntype":"String","maxlength":20,"sumlength":2300980,"count":115993,"countnulls":0,"bitvector":"{0, 1, 2, 3, 4, 5, 6}{0, 1, 2, 3, 4, 5, 6, 7}{0, 1, 2, 3, 4, 5, 6, 7}{0, 1, 2, 3, 4, 5, 6}{0, 1, 2, 3, 4, 5, 6}{0, 1, 2, 3, 4, 5, 6, 10}{0, 1, 2, 3, 4, 5}{0, 1, 2, 3, 4, 5, 7, 8}{0, 1, 2, 3, 4, 5, 6, 7}{0, 1, 2, 3, 4, 5, 6}{0, 1, 2, 3, 4, 5, 6}{0, 1, 2, 3, 4, 5, 6, 8}{0, 1, 2, 3, 4, 5, 7, 9, 10}{0, 1, 2, 3, 4, 5, 6}{0, 1, 2, 3, 4, 5}{0, 1, 2, 3, 4, 5, 6, 10}","numbitvectors":16},"_col39":{"columntype":"String","maxlength":20,"sumlength":944540,"count":47227,"countnulls":68766,"bitvector":"{0, 1, 2, 3}{0, 1, 2, 3}{0, 1, 2, 6}{0, 2, 4, 5, 8}{0, 1, 2, 3, 4}{0, 1, 3, 4}{0, 1, 4}{0, 1, 2, 6}{0, 1, 2}{0, 2, 3}{0, 1, 10}{0, 1, 2}{0, 1, 2, 7}{0, 1}{0, 1, 4, 5}{0, 1, 2, 3}","numbitvectors":16},"_col40":{"columntype":"String","maxlength":1,"sumlength":115993,"count":115993,"countnulls":0,"bitvector":"{2, 4}{0, 3}{0, 1}{2}{0, 2}{1, 2}{0, 2}{0, 3}{0}{1}{0, 1}{0}{1}{0, 1}{0, 7}{0}","numbitvectors":16},"_col41":{"columntype":"String","maxlength":20,"sumlength":88456,"count":115993,"countnulls":0,"bitvector":"{0, 1, 2, 3, 4, 5, 6}{0, 1, 2, 3, 4}{0, 1, 2, 3, 4}{0, 1, 2, 3, 4, 6}{0, 1, 2, 3, 4}{0, 1, 2, 3}{0, 1, 2, 3, 4, 5, 10}{0, 1, 2, 3, 4}{0, 1, 2, 3, 5}{0, 1, 2, 3, 5}{0, 1, 2, 4, 6}{0, 1, 2, 3, 4}{0, 1, 2, 3, 5, 7}{0, 1, 2, 3, 4}{0, 1, 2, 3, 4, 6}{0, 1, 2, 3, 9}","numbitvectors":16},"_col42":{"columntype":"String","maxlength":1,"sumlength":36107,"count":115993,"countnulls":0,"bitvector":"{0, 4}{0}{0}{0, 2}{1, 2}{0, 2}{0}{0, 3}{0}{1}{1, 2}{0, 1}{0, 1}{0, 1}{0, 7}{0}","numbitvectors":16},"_col43":{"columntype":"String","maxlength":19,"sumlength":529623,"count":115993,"countnulls":0,"bitvector":"{0, 1, 2, 3, 4, 5, 6, 7, 8, 9}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10}{0, 1, 2, 3, 4, 5, 6, 7, 8, 13}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 13}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 13}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 11, 12}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10}","numbitvectors":16},"_col44":{"columntype":"String","maxlength":2,"sumlength":140672,"count":115993,"countnulls":0,"bitvector":"{0, 1}{0, 1, 2}{0}{0, 1, 3}{0, 1, 7}{0, 1}{0, 1, 2}{0, 1}{0, 1, 2}{0, 1}{0, 2}{0, 1}{0, 1, 2, 4}{0, 1}{0, 1, 2}{0, 1}","numbitvectors":16},"_col45":{"columntype":"String","maxlength":0,"sumlength":0,"count":0,"countnulls":115993,"bitvector":"{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}","numbitvectors":16},"_col46":{"columntype":"String","maxlength":1,"sumlength":115993,"count":115993,"countnulls":0,"bitvector":"{2, 4}{0, 3}{0, 1}{2}{0, 2}{1, 2}{0, 2}{0, 3}{0}{1}{0, 1}{0}{1}{0, 1}{0, 7}{0}","numbitvectors":16},"_col47":{"columntype":"String","maxlength":0,"sumlength":0,"count":0,"countnulls":115993,"bitvector":"{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}","numbitvectors":16},"_col48":{"columntype":"String","maxlength":3,"sumlength":313686,"count":104562,"countnulls":11431,"bitvector":"{0, 1, 2, 3, 4}{0, 1, 2, 3, 4}{0, 1, 2, 3, 4, 5, 6}{0, 1, 2, 3, 5}{0, 1, 2, 3, 4, 5}{0, 1, 2, 3, 4, 5, 6}{0, 1, 2, 3, 4, 6}{0, 1, 2, 3, 4}{0, 1, 2, 3, 4, 7}{0, 1, 2, 3}{0, 1, 2, 3, 7}{0, 1, 2, 3}{0, 1, 2, 4, 5, 6}{0, 1, 2, 3, 4, 6}{0, 1, 2, 3, 4}{0, 1, 2, 3, 4}","numbitvectors":16},"_col49":{"columntype":"String","maxlength":3,"sumlength":252639,"count":115993,"countnulls":0,"bitvector":"{0, 1, 2, 3, 4, 7}{0, 1, 2, 3, 4, 7}{0, 1, 2, 3, 4, 5, 6}{0, 1, 2, 3, 4, 5}{0, 1, 2, 3, 4, 5}{0, 1, 2, 3, 4, 5, 6}{0, 1, 2, 3, 4, 6}{0, 1, 2, 3, 4}{0, 1, 2, 3, 4, 7}{0, 1, 2, 3}{0, 1, 2, 3, 7}{0, 1, 2, 3, 4}{0, 1, 2, 4, 5, 6}{0, 1, 2, 3, 4, 6}{0, 1, 2, 3, 4, 5}{0, 1, 2, 3, 4, 11}","numbitvectors":16},"_col50":{"columntype":"String","maxlength":3,"sumlength":246327,"count":115993,"countnulls":0,"bitvector":"{0, 1, 2, 3, 4, 7}{0, 1, 2, 3, 4}{0, 1, 2, 3, 4, 5, 6}{0, 1, 2, 3, 5}{0, 1, 2, 3, 4, 5}{0, 1, 2, 3, 4, 5, 6}{0, 1, 2, 3, 4, 6}{0, 1, 2, 3, 4, 5}{0, 1, 2, 3, 7}{0, 1, 2, 3}{0, 1, 2, 3, 7}{0, 1, 2, 3}{0, 1, 2, 4, 5, 6}{0, 1, 2, 3, 4, 6}{0, 1, 2, 3, 4}{0, 1, 2, 3, 4}","numbitvectors":16},"_col51":{"columntype":"String","maxlength":1,"sumlength":59123,"count":115993,"countnulls":0,"bitvector":"{0, 2, 4}{0, 3}{0, 1}{0, 2}{0, 1, 2}{0, 1, 2}{0, 2}{0, 3}{0}{1}{0, 1, 2}{0, 1}{0, 1}{0, 1}{0, 7}{0}","numbitvectors":16},"_col52":{"columntype":"Decimal","min":null,"max":null,"countnulls":115993,"bitvector":"{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}","numbitvectors":16},"_col53":{"columntype":"String","maxlength":0,"sumlength":0,"count":0,"countnulls":115993,"bitvector":"{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}","numbitvectors":16},"_col54":{"columntype":"Decimal","min":null,"max":null,"countnulls":115993,"bitvector":"{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}","numbitvectors":16},"_col55":{"columntype":"String","maxlength":0,"sumlength":0,"count":0,"countnulls":115993,"bitvector":"{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}","numbitvectors":16},"_col56":{"columntype":"String","maxlength":0,"sumlength":0,"count":0,"countnulls":115993,"bitvector":"{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}","numbitvectors":16},"_col57":{"columntype":"String","maxlength":4,"sumlength":104511,"count":115993,"countnulls":0,"bitvector":"{0, 1, 2, 3, 4, 5}{0, 1, 2, 4, 11}{0, 1, 2, 3, 4, 5}{0, 1, 2, 3, 5}{0, 1, 2, 3, 5}{0, 1, 2, 3, 5}{0, 1, 2, 3, 4, 5}{0, 1, 2, 3, 4}{0, 1, 2, 3, 5}{0, 1, 2, 4}{0, 1, 2}{0, 1, 2, 3, 4}{0, 1, 2, 3, 4, 6}{0, 1, 2, 3, 4, 5, 9}{0, 1, 2, 3}{0, 1, 2, 3, 4}","numbitvectors":16},"_col58":{"columntype":"String","maxlength":0,"sumlength":0,"count":0,"countnulls":115993,"bitvector":"{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}","numbitvectors":16},"_col59":{"columntype":"String","maxlength":13,"sumlength":477336,"count":115993,"countnulls":0,"bitvector":"{0, 1, 2, 3, 12}{0, 1, 2, 3, 4}{0, 1, 2, 4}{0, 1, 2, 3}{0, 1, 2, 3, 8, 10}{0, 1, 2, 3, 4}{0, 1, 2, 5}{0, 1, 2, 4}{0, 1, 2, 3}{0, 1, 4, 5}{0, 1, 2, 3, 4}{0, 1, 2, 3}{0, 1, 2, 3, 7}{0, 1, 2, 3, 9}{0, 1, 2, 7}{0, 1, 2, 4}","numbitvectors":16},"_col60":{"columntype":"Long","min":null,"max":null,"countnulls":115993,"bitvector":"{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}","numbitvectors":16},"_col61":{"columntype":"Long","min":null,"max":null,"countnulls":115993,"bitvector":"{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}","numbitvectors":16},"_col62":{"columntype":"String","maxlength":56,"sumlength":948740,"count":115993,"countnulls":0,"bitvector":"{0, 1, 2, 3, 4, 5, 6, 7, 8}{0, 1, 2, 3, 4, 5, 6, 7, 8}{0, 1, 2, 3, 4, 5, 6, 7}{0, 1, 2, 3, 4, 5, 6, 10}{0, 1, 2, 3, 4, 5, 6, 7, 8, 10}{0, 1, 2, 3, 4, 5, 6, 7, 10, 13}{0, 1, 2, 3, 4, 5, 7}{0, 1, 2, 3, 4, 5, 6, 7, 8}{0, 1, 2, 3, 4, 5, 6, 7}{0, 1, 2, 3, 4, 5, 7, 8}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11}{0, 1, 2, 3, 4, 5, 6, 7, 12, 17}{0, 1, 2, 3, 4, 5, 6, 8, 13}{0, 1, 2, 3, 4, 5, 6}{0, 1, 2, 3, 4, 5, 7, 9, 10}{0, 1, 2, 3, 4, 5, 6, 8}","numbitvectors":16},"_col63":{"columntype":"String","maxlength":56,"sumlength":739169,"count":115993,"countnulls":0,"bitvector":"{0, 1, 2, 3, 4, 5, 6, 7, 8}{0, 1, 2, 3, 4, 5, 6, 7, 8, 10}{0, 1, 2, 3, 4, 5, 6, 7}{0, 1, 2, 3, 4, 5, 6, 10}{0, 1, 2, 3, 4, 5, 6, 8, 10}{0, 1, 2, 3, 4, 5, 6, 7, 13}{0, 1, 2, 3, 4, 5, 6, 9}{0, 1, 2, 3, 4, 5, 6, 7}{0, 1, 2, 3, 4, 5, 7, 8}{0, 1, 2, 3, 4, 5, 6, 7, 9}{0, 1, 2, 3, 4, 5, 8, 9, 10, 11}{0, 1, 2, 3, 4, 5, 6, 7, 12, 17}{0, 1, 2, 3, 4, 5, 6, 7, 8, 13}{0, 1, 2, 3, 4, 5, 6}{0, 1, 2, 3, 4, 5, 6, 7, 14}{0, 1, 2, 3, 4, 5, 6, 7, 8, 10}","numbitvectors":16},"_col64":{"columntype":"String","maxlength":0,"sumlength":0,"count":0,"countnulls":115993,"bitvector":"{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}","numbitvectors":16},"_col65":{"columntype":"String","maxlength":3,"sumlength":72573,"count":35804,"countnulls":80189,"bitvector":"{0, 1, 2, 3, 4, 5, 6}{0, 1, 2, 3, 4, 5, 11}{0, 1, 2, 3, 4, 5, 6}{0, 1, 2, 3, 4, 5}{0, 1, 2, 3, 5}{0, 1, 2, 3, 4, 5, 6}{0, 1, 2, 3, 4, 5, 6, 8}{0, 1, 2, 3, 4, 5, 7}{0, 1, 2, 3, 4, 5}{0, 1, 2, 3, 4, 6}{0, 1, 2}{0, 1, 2, 3, 4, 7}{0, 1, 2, 3, 4, 5, 6}{0, 1, 2, 3, 4, 5, 9}{0, 1, 2, 3, 4, 5, 6}{0, 1, 2, 3, 4, 6}","numbitvectors":16},"_col66":{"columntype":"Long","min":null,"max":null,"countnulls":115993,"bitvector":"{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}","numbitvectors":16},"_col67":{"columntype":"Long","min":null,"max":null,"countnulls":115993,"bitvector":"{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}","numbitvectors":16},"_col68":{"columntype":"Decimal","min":null,"max":null,"countnulls":115993,"bitvector":"{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}","numbitvectors":16},"_col69":{"columntype":"String","maxlength":0,"sumlength":0,"count":0,"countnulls":115993,"bitvector":"{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}","numbitvectors":16},"_col70":{"columntype":"Decimal","min":null,"max":null,"countnulls":115993,"bitvector":"{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}","numbitvectors":16},"_col71":{"columntype":"String","maxlength":0,"sumlength":0,"count":0,"countnulls":115993,"bitvector":"{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}","numbitvectors":16},"_col72":{"columntype":"String","maxlength":1,"sumlength":115993,"count":115993,"countnulls":0,"bitvector":"{2, 4}{0, 3}{0, 1}{2}{0, 2}{1, 2}{0, 2}{0, 3}{0}{1}{0, 1}{0}{1}{0, 1}{0, 7}{0}","numbitvectors":16},"_col73":{"columntype":"String","maxlength":0,"sumlength":0,"count":0,"countnulls":115993,"bitvector":"{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}","numbitvectors":16},"_col74":{"columntype":"Decimal","min":0,"max":18670970726.27,"countnulls":10562,"bitvector":"{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 19}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 18}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 17}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 18}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 17}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17}{0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15}","numbitvectors":16},"_col75":{"columntype":"String","maxlength":0,"sumlength":0,"count":0,"countnulls":115993,"bitvector":"{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}","numbitvectors":16},"_col76":{"columntype":"String","maxlength":15,"sumlength":926685,"count":115993,"countnulls":0,"bitvector":"{0, 1, 2, 3, 4}{0, 1, 2, 3, 4, 8}{0, 1, 2, 4, 5, 6}{0, 1, 2, 3}{0, 1, 2, 3, 4, 5, 8}{0, 1, 2, 3, 4, 5, 6, 7}{0, 1, 2, 4, 6}{0, 1, 2, 3, 5, 9}{0, 1, 2, 3, 4, 5}{0, 1, 2, 3, 5}{0, 1, 2, 3, 4, 5, 6, 7}{0, 1, 2, 3, 4}{0, 1, 2, 3, 5, 8}{0, 1, 2, 3, 5, 6, 7}{0, 1, 2, 3, 4, 6}{0, 1, 2, 3, 4, 5}","numbitvectors":16},"_col77":{"columntype":"String","maxlength":0,"sumlength":0,"count":0,"countnulls":115993,"bitvector":"{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}","numbitvectors":16},"_col78":{"columntype":"String","maxlength":20,"sumlength":1715564,"count":115993,"countnulls":0,"bitvector":"{0, 1, 2, 3, 4, 5, 6}{0, 1, 2, 3, 4, 5}{0, 1, 2, 3, 4, 5, 6}{0, 1, 2, 3, 4, 5, 6}{0, 1, 2, 3, 4, 5, 6, 7}{0, 1, 2, 3, 4, 5, 6}{0, 1, 2, 3, 4, 5, 6, 7, 8, 10}{0, 1, 2, 3, 4, 5}{0, 1, 2, 3, 4, 5, 7}{0, 1, 2, 3, 4, 5, 9, 10}{0, 1, 2, 3, 4, 5, 6}{0, 1, 2, 3, 4, 5, 6}{0, 1, 2, 3, 4, 5, 7}{0, 1, 2, 3, 4, 5, 6, 7}{0, 1, 2, 3, 4, 6}{0, 1, 2, 3, 4, 5, 8}","numbitvectors":16},"_col79":{"columntype":"String","maxlength":0,"sumlength":0,"count":0,"countnulls":115993,"bitvector":"{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}","numbitvectors":16},"_col80":{"columntype":"String","maxlength":0,"sumlength":0,"count":0,"countnulls":115993,"bitvector":"{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}","numbitvectors":16},"_col81":{"columntype":"String","maxlength":1,"sumlength":115390,"count":115993,"countnulls":0,"bitvector":"{0, 1, 5}{0, 1}{0, 1}{0, 1}{0, 1, 2}{0, 4}{0, 1}{0, 1, 3}{0, 1}{1}{1, 2}{1}{0, 3}{0, 1}{0, 2, 5}{0, 1, 3}","numbitvectors":16},"_col82":{"columntype":"String","maxlength":0,"sumlength":0,"count":0,"countnulls":115993,"bitvector":"{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}","numbitvectors":16},"_col83":{"columntype":"String","maxlength":0,"sumlength":0,"count":0,"countnulls":115993,"bitvector":"{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}","numbitvectors":16},"_col84":{"columntype":"Date","min":null,"max":null,"countnulls":115993,"bitvector":"{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}","numbitvectors":16},"_col85":{"columntype":"Long","min":null,"max":null,"countnulls":115993,"bitvector":"{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}","numbitvectors":16},"_col86":{"columntype":"String","maxlength":1,"sumlength":103605,"count":115993,"countnulls":0,"bitvector":"{0, 3}{0, 1}{0, 1}{0}{1, 3}{0, 2}{0}{0, 6}{0, 1}{1}{0, 2, 3}{0, 1}{0}{0, 1, 5}{0, 1, 4}{0, 1, 2}","numbitvectors":16},"_col87":{"columntype":"Decimal","min":null,"max":null,"countnulls":115993,"bitvector":"{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}","numbitvectors":16},"_col88":{"columntype":"String","maxlength":0,"sumlength":0,"count":0,"countnulls":115993,"bitvector":"{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}","numbitvectors":16},"_col89":{"columntype":"Decimal","min":null,"max":null,"countnulls":115993,"bitvector":"{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}","numbitvectors":16},"_col90":{"columntype":"String","maxlength":0,"sumlength":0,"count":0,"countnulls":115993,"bitvector":"{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}","numbitvectors":16},"_col91":{"columntype":"String","maxlength":12,"sumlength":1391916,"count":115993,"countnulls":0,"bitvector":"{0}{0}{1}{2}{0}{0}{1}{3}{1}{2}{0}{0}{0}{0}{3}{3}","numbitvectors":16},"_col92":{"columntype":"String","maxlength":0,"sumlength":0,"count":0,"countnulls":115993,"bitvector":"{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}","numbitvectors":16}}} at org.apache.hadoop.hive.ql.exec.tez.TezProcessor.initializeAndRunProcessor(TezProcessor.java:173) at org.apache.hadoop.hive.ql.exec.tez.TezProcessor.run(TezProcessor.java:139) at org.apache.tez.runtime.LogicalIOProcessorRuntimeTask.run(LogicalIOProcessorRuntimeTask.java:347) at org.apache.tez.runtime.task.TezTaskRunner$TaskRunnerCallable$1.run(TezTaskRunner.java:194) at org.apache.tez.runtime.task.TezTaskRunner$TaskRunnerCallable$1.run(TezTaskRunner.java:185) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAs(Subject.java:415) at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1724) at org.apache.tez.runtime.task.TezTaskRunner$TaskRunnerCallable.callInternal(TezTaskRunner.java:185) at org.apache.tez.runtime.task.TezTaskRunner$TaskRunnerCallable.callInternal(TezTaskRunner.java:181) at org.apache.tez.common.CallableWithNdc.call(CallableWithNdc.java:36) at java.util.concurrent.FutureTask.run(FutureTask.java:262) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:745) Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: Hive Runtime Error while processing row (tag=0) {"key":{"_col0":"state","_col1":2017,"_col2":9,"_col3":29},"value":{"_col0":

olumntype":"String","maxlength":0,"sumlength":0,"count":0,"countnulls":114597,"bitvector":"{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}","numbitvectors":16}}} at org.apache.hadoop.hive.ql.exec.tez.TezProcessor.initializeAndRunProcessor(TezProcessor.java:173) at org.apache.hadoop.hive.ql.exec.tez.TezProcessor.run(TezProcessor.java:139) at org.apache.tez.runtime.LogicalIOProcessorRuntimeTask.run(LogicalIOProcessorRuntimeTask.java:347) at org.apache.tez.runtime.task.TezTaskRunner$TaskRunnerCallable$1.run(TezTaskRunner.java:194) at org.apache.tez.runtime.task.TezTaskRunner$TaskRunnerCallable$1.run(TezTaskRunner.java:185) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAs(Subject.java:415) at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1724) at org.apache.tez.runtime.task.TezTaskRunner$TaskRunnerCallable.callInternal(TezTaskRunner.java:185) at org.apache.tez.runtime.task.TezTaskRunner$TaskRunnerCallable.callInternal(TezTaskRunner.java:181) at org.apache.tez.common.CallableWithNdc.call(CallableWithNdc.java:36) at java.util.concurrent.FutureTask.run(FutureTask.java:262) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:745) Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: Hive Runtime Error while processing row (tag=0) {"key":{"_col0":"state","_col1":2017,"_col2":9,"_col3":29},"value":{"_col0": "columntype":"String","maxlength":0,"sumlength":0,"count":0,"countnulls":114597,"bitvector":"{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}","numbitvectors":16}}} at org.apache.hadoop.hive.ql.exec.tez.ReduceRecordSource$GroupIterator.next(ReduceRecordSource.java:352) at org.apache.hadoop.hive.ql.exec.tez.ReduceRecordSource.pushRecord(ReduceRecordSource.java:237) at org.apache.hadoop.hive.ql.exec.tez.ReduceRecordProcessor.run(ReduceRecordProcessor.java:252) at org.apache.hadoop.hive.ql.exec.tez.TezProcessor.initializeAndRunProcessor(TezProcessor.java:150) ... 14 more Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.NullPointerException at org.apache.hadoop.hive.ql.exec.GroupByOperator.process(GroupByOperator.java:766) at org.apache.hadoop.hive.ql.exec.tez.ReduceRecordSource$GroupIterator.next(ReduceRecordSource.java:343) ... 17 more Caused by: java.lang.NullPointerException at org.apache.hadoop.hive.serde2.lazybinary.LazyBinaryHiveDecimal.init(LazyBinaryHiveDecimal.java:47) at org.apache.hadoop.hive.serde2.lazybinary.LazyBinaryStruct.uncheckedGetField(LazyBinaryStruct.java:267) at org.apache.hadoop.hive.serde2.lazybinary.LazyBinaryStruct.getField(LazyBinaryStruct.java:204) at org.apache.hadoop.hive.serde2.lazybinary.objectinspector.LazyBinaryStructObjectInspector.getStructFieldData(LazyBinaryStructObjectInspector.java:64) at org.apache.hadoop.hive.ql.udf.generic.GenericUDAFComputeStats$GenericUDAFNumericStatsEvaluator.merge(GenericUDAFComputeStats.java:549) at org.apache.hadoop.hive.ql.udf.generic.GenericUDAFEvaluator.aggregate(GenericUDAFEvaluator.java:188) at org.apache.hadoop.hive.ql.exec.GroupByOperator.updateAggregations(GroupByOperator.java:612) at org.apache.hadoop.hive.ql.exec.GroupByOperator.processAggr(GroupByOperator.java:851) at org.apache.hadoop.hive.ql.exec.GroupByOperator.processKey(GroupByOperator.java:695) at org.apache.hadoop.hive.ql.exec.GroupByOperator.process(GroupByOperator.java:761) ... 18 more

3 REPLIES 3

@Olivia Smith

From the logs, I do observe that the analyze statement is being run with Hive 2.x.

Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: Hive Runtime Error while processing row (tag=0) {"key":{"_col0":"state","_col1":2017,"_col2":9,"_col3":29},"value":{"_col0": "columntype":"String","maxlength":0,"sumlength":0,"count":0,"countnulls":114597,"bitvector":"{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}{}","numbitvectors":16}}}

This issue could be due to the analyze statements run from both Hive 1.2.1 and Hive 2.x.

Ideally, analyze statements needs to be run from one version alone to be inline with the backend metadata for the table.

For example, if the analyze statement is run from Hive 1.2.1, then the metadata for the statistics would not include 'bitvector'. And, next run from Hive 2.x would try to update the same metadata and would result in the error as above.

Here you will be able to know that we are going to share one of the best portal payday online loans which will help you to know about how you can have payday loans as it includes all essential features which will help you in the same process so make use of it.

Explorer

Thank you Sindhu for your reply.

How can you be sure they are using Hive 2.x..

There are 2 hive servers installed both using the same metastore. But all using Hive 1.2.1 as part of the HDP 2.5.0 installation

; ;