Load Instance: Couldn't read from database. Method not supported.

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Load Instance: Couldn't read from database. Method not supported.

wekawebb
This post was updated on .
SqlViewer_QueryExecuted_InfoPanel_Text_Sixth=Unknown number of rows selected (due to JDBC driver restrictions).  jdbcDriver=org.apache.hive.jdbc.HiveDriver





>>> Status:  Problem executing DB query SELECT * FROM ? <<<

Hive connection is good.
DatabaseUtils.prop is set up for hive.
Have addressed all datatype assignments which prevented data loading and
entered every keyword for hive.

Troubleshooting new error message:

"Load Instance:  Couldn't read from database.  Method not supported."

There is something (JDBC Driver Restrictions??/no index on table??) which is not allowing database results to load instances to the explorer.

Any help greatly appreciated, thank you



Please see DatabaseUtils.props below:

# Database settings for Apache Hive 0.7.0.
#
# IMPORTANT: Hive only supports a limited subset of SQL-like
# functionality. The JDBC driver only supports reading from
# tables.
#
# General information on database access can be found here:
# http://weka.wikispaces.com/Databases
#
# url:     http://hive.apache.org/
# jdbc:    https://github.com/pentaho/hive
# author:  Mark Hall (mhall{[at]}pentaho{[dot]}com)
# version: $Revision: $

# JDBC driver (comma-separated list)
#jdbcDriver=org.apache.hive.jdbc.HiveDriver
jdbcDriver=org.apache.hive.jdbc.HiveDriver

# auto commit is not supported by hive
setAutoCommit=false

# database URL
jdbcURL=jdbc:hive2://myserver:myport/default

# the method that is used to retrieve values from the db
# (java datatype + RecordSet.<method>)

# specific data types
# string, getString() = 0;    --> nominal
# boolean, getBoolean() = 1;  --> nominal
# double, getDouble() = 2;    --> numeric
# byte, getByte() = 3;        --> numeric
# short, getByte()= 4;        --> numeric
# int, getInteger() = 5;      --> numeric
# long, getLong() = 6;        --> numeric
# float, getFloat() = 7;      --> numeric
# date, getDate() = 8;        --> date
# text, getString() = 9;      --> string
# time, getTime() = 10;       --> date
# the original conversion: <column type>=<conversion>

BOOLEAN=1
boolean=1
TINYINT=3
tinyint=3
SMALLINT=3
smallint=3
INT=5
int=5
BIGINT=6
bigint=6
FLOAT=7
float=7
DOUBLE=2
double=2
STRING=0
string=0

decimal=7
varchar=9
NUMBER=5
VARCHAR2=0
DATETIME=10
VARCHAR=9
DECIMAL(38,12)=9
VARCHAR(10)=0
timestamp=10
date=8

# MAPPINGS FOR TABLE CREATION
CREATE_STRING=STRING
CREATE_INT=INT
CREATE_DOUBLE=DOUBLE
CREATE_DATE=DATETIME
DateFormat=yyyy-MM-dd HH:mm:ss

# DATABASE FLAGS
checkUpperCaseNames=false
checkLowerCaseNames=false
checkForTable=true

# OTHER DATABASE FLAGS NOT SURE IF NEEDED OR SHOULD BE INCLUDED
setAutoCommit=false
createIndex=true

# All the reserved keywords for this database
Keywords=\
  ALL,\
  ALTER,\
  AND,\
  ARRAY,\
  AS,\
  AUTHORIZATION,\
  BETWEEN,\
  BIGINT,\
  BINARY,\
  BOOLEAN,\
  BOTH,\
  BY,\
  CACHE,\
  CASE,\
  CAST,\
  CHAR,\
  COLUMN,\
  COMMIT,\
  CONF,\
  CONSTRAINT,\
  CREATE,\
  CROSS,\
  CUBE,\
  CURRENT,\
  CURRENT_DATE,\
  CURRENT_TIMESTAMP,\
  CURSOR,\
  DATABASE,\
  DATE,\
  DAYOFWEEK,\
  DECIMAL,\
  DELETE,\
  DESCRIBE,\
  DISTINCT,\
  DOUBLE,\
  DROP,\
  ELSE,\
  END,\
  EXCHANGE,\
  EXISTS,\
  EXTENDED,\
  EXTERNAL,\
  EXTRACT,\
  FETCH,\
  FLOAT,\
  FLOOR,\
  FOLLOWING,\
  FOR,\
  FOREIGN,\
  FROM,\
  FULL,\
  FUNCTION,\
  GRANT,\
  GROUP,\
  GROUPING,\
  HAVING,\
  IF,\
  IMPORT,\
  IN,\
  INNER,\
  INSERT,\
  INT,\
  INTEGER,\
  INTERSECT,\
  INTERVAL,\
  INTO,\
  IS,\
  JOIN,\
  LATERAL,\
  LEFT,\
  LESS,\
  LIKE,\
  LOCAL,\
  MACRO,\
  MAP,\
  MORE,\
  NONE,\
  NOT,\
  NULL,\
  OF,\
  ON,\
  ONLY,\
  OR,\
  ORDER,\
  OUT,\
  OUTER,\
  OVER,\
  PARTIALSCAN,\
  PARTITION,\
  PERCENT,\
  PRECEDING,\
  PRECISION,\
  PRESERVE,\
  PRIMARY,\
  PROCEDURE,\
  RANGE,\
  READS,\
  REDUCE,\
  REFERENCES,\
  REGEXP,\
  REVOKE,\
  RIGHT,\
  RLIKE,\
  ROLLBACK,\
  ROLLUP,\
  ROW,\
  ROWS,\
  SELECT,\
  SET,\
  SMALLINT,\
  START,\
  TABLE,\
  TABLESAMPLE,\
  THEN,\
  TIMESTAMP,\
  TO,\
  TRANSFORM,\
  TRIGGER,\
  TRUNCATE,\
  UNBOUNDED,\
  UNION,\
  UNIQUEJOIN,\
  UPDATE,\
  USER,\
  USING,\
  UTC_TMESTAMP,\
  VALUES,\
  VARCHAR,\
  VIEWS,\
  WHEN,\
  WHERE,\
  WINDOW,\
  WITH,\
  FALSE,\
  TRUE

# The character to append to attribute names to avoid exceptions due to
# clashes between keywords and attribute names
KeywordsMaskChar=_

#flags for loading and saving instances using DatabaseLoader/Saver
nominalToStringLimit=50
idColumn=auto_generated_id



--
Sent from: https://weka.8497.n7.nabble.com/
_______________________________________________
Wekalist mailing list -- wekalist@list.waikato.ac.nz
Send posts to: To unsubscribe send an email to wekalist-leave@list.waikato.ac.nz
To subscribe, unsubscribe, etc., visit
https://list.waikato.ac.nz/postorius/lists/wekalist.list.waikato.ac.nz
List etiquette: http://www.cs.waikato.ac.nz/~ml/weka/mailinglist_etiquette.html