错误:data type not supported 1111

在通过impala操作hive时,会出现data type not supported 1111这个错误,我这个工程中,这样的错误基本都是sql传参名错误。

例如我前台的传值参数名为:city 。

后台的sql写成:

select town from sys_area where city=#{cityName}

这样写就会报这个错误

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
Type inheritance is that phenomenon according to which we can say, for example, that every square is also a rectangle, and so properties that apply to rectangles in general apply to squares in particular. In other words, squares are a subtype of rectangles, and rectangles are a supertype of squares. Recognizing and acting upon such subtype / supertype relationships provides numerous benefits: Certainly it can help in data modeling, and it can also provide for code reuse in applications. For these reasons, many languages, including the standard database language SQL, have long supported such relationships. However, there doesn’t seem to be any consensus in the community at large on a formal, rigorous, and abstract model of inheritance. This book proposes such a model, one that enjoys several advantages over other approaches, not the least of which it is that it’s fully compatible with the well known relational model of data. Topics the model covers include: Both single and multiple inheritance Scalar, tuple, and relation inheritance Type lattices and union and intersection types Polymorphism and substitutability Compile time and run time binding All of these topics are described in detail in the book, with numerous illustrative examples, exercises, and answers. The book also discusses several alternative approaches. In particular, it includes a detailed discussion and analysis of inheritance as supported in the SQL standard. Table of Contents PART I PRELIMINARIES Chapter 1 Background Chapter 2 Types without Inheritance Chapter 3 Types with Inheritance Chapter 4 The Inheritance Model PART II SCALAR TYPES, SINGLE INHERITANCE Chapter 5 Basic Definitions Chapter 6 Scalar Values with Inheritance Chapter 7 Scalar Variables with Inheritance Chapter 8 Specialization by Constraint etc. Chapter 9 Equality Comparisons etc. Chapter 10 Treating and Type Testing Chapter 11 Substitutability Chapter 12 Union and Dummy Types Chapter 13 Interlude: The S by C Controversy PART III SCALAR TYPES, MULTIPLE INHERITANCE Chapter 14 An Overview of Multiple Inheritance Chapter 15 IM Prescriptions 8 - 9 Revisited Chapter 16 IM Prescriptions 10 - 20 Revisited PART IV TUPLE AND RELATION INHERITANCE Chapter 17 Tuple / Relation Values with Inheritance Chapter 18 Tuple / Relation Values with Inheritance (cont.) Chapter 19 Tuple / Relation Maximal and Minimal Types etc. Chapter 20 Tuple / Relation Variables with Inheritance PART V OTHER APPROACHES Chapter 21 Structural Inheritance Chapter 22 Inheritance in SQL Appendix A Encapsulation Is a Red Herring Appendix B Persistence Not Orthogonal to Type Appendix C Glossary of Terms

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值